Form updating table

[mikepsc]

Hi. I'm kinda new to Access and object oriented programming (i'm a mainframer with over 20 years of structured Cobol coding), so please bear with me if this sounds like a stupid question. I have a form (linked to a table via the form's 'record source'). It appears that whenever I either exit the form, tab past the last field on the form, or use the mouse wheel, Access will update the record displayed in the form and attempt to retrieve the next record (if still processing the form). Is there any way to stop this (maybe in VBA), and have updates only occur when a command button is pressed? I.e., I have a command button on the form that lets the user back-out and return to a 'selection menu" form, but when it is pressed, the record is still being updated. Thanks.

 

[mp9]

You can try using the form's BeforeUpdate event to incorporate a "want to save changes Y/N?" prompt...

 

[mikepsc]

Thanks for the quick response, mp9! I dodn't realize that there was a Beforeupdate event at the form level (i've seen it at the individual field level before.) So, I would just need to set the "cancel" parameter to "true" (?) and that would stop the update? Thanks again.