Saving Record only when Save Button Pressed

[Bert666]

Hi there People,

I was just wondering if there is a way a record is saved or written to the table only when a save button is pressed rather than having it saved when the user types???.

Bert.

 

[Rob.Mills]

If your form is bound to a table or query then it will automatically update as you move from record to record.

The only way I know to make it so that the user has to click a Save button is to create an unbound form with the correct boxes and when the user clicks the button it will run a procedure that opens the table in memory and adds a new record with the data in the form.

 

[ghudson]

Check out my A better mouse trap? sample. The method I used to prevent a scroll wheel mouse from moving to another record will also prevent a user from advancing to another record or close the form unless they use my custom Save button. You will be amazed at how simple my solution is to ensure a record is saved or undone if it was modified.

HTH