Record updates not to be automatic

[dbuuch]

I have a form which i would like to use to update multiple records. This for has an underlying query which populates it. I also have two buttons at the bottom of the form to update the records and close form without updating records respectively.

Unfortunately whenever i change any field on my form (records) it doesn't matter whether i closed the form without updating or not, the underlying records still gets updated when i close the form and open it up again.

is there a property of the form that i can set so nothing gets updated until I, Mr Buuch, ask that the records be updated by way of my "Save" button?

Thanks,
Dee

"To educate a man is to educate an individual; to educate a woman is to educate a nation"
Dr. Aggrey, Ghana.

 

[Eupher]

Several ways you could approach this...

Maybe the most direct way - in the form's close event:

If Me.Dirty Then Me.Undo

You may want to trap the F9 keystroke and perhaps disable the standard menus so that users can't save the record via any other means than your Save button.

HTH,

Ken S.

 

[Remou]

Hi
With a bound form records will update unless you undo them. You could use unbound text boxes etc and write the data to your table using the save button.