printing invoice, need to requery? (1 Viewer)

[deekras]

i want to print an invoice right after entering the data. however, as i have it set up now, i must always go to the next record and tehn back again to get the info on teh report. i suppose i need to requery. but i don't know how to do it.

suggestions?

 

[Rich]

Again you will find most of the answers to your posts in the solutions database and in the other samples provided by microsoft.

 

[deekras]

i did try to find the answers with the sample databases. couldn't find the answer to this one. any suggestions?

 

[Rich]

Try adding Me.Requery to the command button before the open report statement.

 

[Pat Hartman]

You must save the current record before you print the invoice. Add the following line of code to the click event of your print button prior to the print command:

DoCmd.RunCommand acCmdSaveRecord