Update form on click

[DavidCantor]

I have two forms, when the user has finished the data entry in the 1st form they click on a button which opens a second form, how do I save the data on the first form Onexit?

 

[pr2-eugin]

On the button click that opens another form, just run the save command??

 

[Trevor G]

If the data is on the first form is to be saved then when the form is closed it should automatically save to a table if the form is using the source control to that table, and the same applies on the exist event it should automatically save to the table.

So if this isn't happening then please try and explain the situation and also if possible upload an example of the database with the 2 forms and table(s).

 

[DavidCantor]

what is the syntax to save the data?

 

[DavidCantor]

If the data is on the first form is to be saved then when the form is closed it should automatically save to a table if the form is using the source control to that table, and the same applies on the exist event it should automatically save to the table.

the form does not close onexit

how do i get the form to close when I click the button to move to the 2nd form?

 

[Trevor G]

Open the form in design view then select the button and open the properties look at the On Click Event and then use the Ellipse button on the right and this will take you into the code, then add the following before the Open Form.

Docmd.Close