Submit Button Code

[GWhelan]

Hi Folks,

I have a button on my form that the form's users will click to "submit" their entry to the database. When I first designed the form, I used a macro which would save the info as a new record in a table, and then would pull up a new blank record for another entry if needed. This method worked fine for simple data entry, but now I need a bit more.

Now, every time the "submit" button is clicked I need it to do what the current macro does today, but I also need it to run an append query as well as disabling the pop up messages such as "do you want to add 1 record to this table", etc.

The idea is that the users of the form should never know this query is being run in the background.

I'd really appreciate any help the community can provide!

 

[plog]

Check out this link:

https://support.office.com/en-gb/ar...n-or-off-e58e4bba-9d54-4b9d-b962-9eca048e5335

You can do it with code, or disable that feature in each user's version of Access. However, I have to ask--why a Submit button and not just use the table as the form's record source and avoid this altogether?

 

[GWhelan]

You can do it with code, or disable that feature in each user's version of Access. However, I have to ask--why a Submit button and not just use the table as the form's record source and avoid this altogether?

Well, the biggest reason for the submit button would be the fact that the individuals who will be using this form have requested it. Most of them are not very...tech savvy and they prefer having something tactile like a button to add the record to the table vs simply tabbing through to a new record. It was a struggle just to get them to agree to use access!