I don't like how the fields on a form are automatically overwritten, is there a way to add a "submit" button that processes the update all at once?
I don't like how the fields on a form are automatically overwritten, is there a way to add a "submit" button that processes the update all at once?
The data is changed on the form, but it hasn't offically been written/committed to the table until you leave the entire record (either scroll forward/backward or force a save). So even though it doesn't appear that way, the entire change is still pending field to field. As a result, you could add an Undo button to your form (as well as a Save button so the user could manually commit the data). These buttons exist in the wizards, but if you don't have them:
The underlying code for undo (which is triggered on the button's click event is:
DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
Save is:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
There are other options, such as having an unbound form and manually loading the data, then forcing the user to click save and, through code, committing that data back to the table. These can get a little tricky if you're inexperienced in Access VBA.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks