Problems with forms auto saving data

[rasticle]

I have created a database with Access. I don't know if this is a built in function or if I just need to change a property setting somewhere, but on all the forms when you enter data Access automatically starts saving the data, without having to use a save button. How do I remove this? Do I need to write some VBA code to save all the values of the text boxes, etc, into variables before I can get the save button to work properly? If this is unclear I appologize, I'm trying to be as descriptive as possible.

Thanks,
Shawn

 

[PHV]

This is standard behaviour for bound forms.
A common way is to enforce all the validation rules in the BeforeUpdate event procedure of the form, playing with the Cancel argument and the SetFocus method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[rasticle]

Will I have to do a cancel for every textbox, or is there a more efficient way to do it? Like a loop to look through an array of all the text boxes?