Edited: Dec 22, 2018
I have created the above database and I have successfully connected all of the above fields to my database. I then created my submit button and then I connected to the database but the Submit function(see above) is lighter than the rest of the selections and will not allow the submit function to be selected. I have rechecked my permissions and all can submit as shown in the screenshot.
Did you ever get this figured out? I have the same problem but not with every button So far 2 out of 3 are this way.
You need to check your dataset settings and what your dataset is set to out of read only, read and write or write only.