How to Save the data in a new form

[DavidCdp1]

Hi Everyone,

I have a form with several fields bound to a table. Normally when I open the form the form shows the firsts record data in that table. When I want to add a new record then i use the default navigation bar to go to the last record. After entering the data, I have a button on that form that prints the data. When I click the button, I can't see anything in the report. But when I navigate to previous record and come back to the latest record that I added and press the print button then i can see the data in the report. Is it possible for me to have a button on the form like "Save" button, that saves the data and then i can print the details without going to previous record and come back. Please help.
Thanks,
DavidCdp1.

 

[Uncle Gizmo]

The command button wizard has the option to create a save button for you....

 

[DavidCdp1]

Thanks for your help..Uncle Gizmo..
Really helpful..
Cheers..
DavidCdp1.

 

[Pat Hartman]

I wouldn't rely on having the user press a button to make this happen. Put the save command in the click event for your print button just before the OpenReport method.

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport ......