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.