Message Box for Saving Record

[Mahavir]

hey guys i want to have message box asking "Want to save the record or not" to save the record.

form contain the subform also. i read some thread regarding that issue they suggest i have to use form's beforeupdate property. i used it for the main form but message box is appearing before entering the values in subform. i mean i have to enter some data in subform also.

i am attaching database for ur references. after entering PO nunber PO date and selecting client message box is apearing but it should be come after updating data in subform i.e. details.

kindly help me and guide accordingly.

[RuralGuy]

The mainForm will attempt to save the Current record (if it is Dirty) as soon as you try to move the focus to the SubForm.

[Mahavir]

pls give some example....

The mainForm will attempt to save the Current record (if it is Dirty) as soon as you try to move the focus to the SubForm.

[RuralGuy]

If you re-read my post you will see that what you are getting is the expected behavior of Access with a Form/SubForm arrangement. You have the example.

[Mahavir]

i got ur point but i am just asking u that which event of which form either mainForm or subform i have to select to put my code for saving the record after asking the user through message box.

If you re-read my post you will see that what you are getting is the expected behavior of Access with a Form/SubForm arrangement. You have the example.

[RuralGuy]

The BeforeUpdate event is the correct event but you have two, one in the MainForm and one in the SubForm. Not saving the MainForm recortd until you have SubForm records is a more complicated problem.