when data is updated in a form??

[gdanalakshmi]

I have a MainForm that is associated with a table. The form has 15 control and most of them are text boxes and a few combo boxes are also there.
I have a button that taked me to another form (Form2)

My question is if I am adding a new record to the main form when will the data be updated??

Suppose if i fill few text boxes and click the button that takes me to Form2, then the data is not updated in the MainForm.

 

[Autoeng]

Anytime that the form loses focus the record is saved. This includes moving from form to subform and back again.

Autoeng

 

[Pat Hartman]

Not everything that causes a form to loose focus saves the current record. It does NOT include button clicks that open other forms or reports. If you need the current record to be saved before you open the related form, then do the following in the button click event, prior to the OpenForm method:

DoCmd.Runcommand acCmdSaveRecord