View Single Post
Old 01-21-2008, 10:50 AM   #1
Registered User
Join Date: Oct 2005
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
patkeaveney is on a distinguished road
Only save record in subform when a save button is pressed


I have a main form with several command buttons.

When a new record is added to the sub form . I dont want access to update the record automatically.
I only want the record Saved when a Save buton is pressed on the main form
(This is to allow certain validation on the subform/main form to be completed.)

At the moment the subform record is saved as soon as i move from the subform (eg press one of the other command buttons).

Any help would be greatly welcomed.

Pat Keaveney

patkeaveney is offline   Reply With Quote