Edit/Save Data via form control

[Guest]

I have a form used for editing data.

I want the user to be able to edit the data but they must use a save button
before the information updates the data table.
i.e. enter data - click save button.

I do NOT want the records to update automatically when they scroll to a new
record or when they close the window. I want to prompt them to save via a msg
box of some sort if they close the window. If the user clicks an exit/cancel
button I wish the data to remain as it originally was.

Is there a way to control what happens to the data?

 

[wendy wilson]

I have a form used for editing data.

I want the user to be able to edit the data but they must use a save
button
before the information updates the data table.
i.e. enter data - click save button.

I do NOT want the records to update automatically when they scroll to a
new
record or when they close the window. I want to prompt them to save via a
msg
box of some sort if they close the window. If the user clicks an
exit/cancel
button I wish the data to remain as it originally was.

Is there a way to control what happens to the data?

 

[Douglas J Steele]

The only ways to prevent Access from automatically updating are to use an
Unbound form, or to put logic in the form's BeforeUpdate (and possibly
BeforeInsert) events to prevent the update from occurring.