Printing a report based on the current (new) record

[Dougalsworld]

Hi All,

Having a problem with a report, I have a form that i use to enter a new record to my database, what I want to do is put a button at the bottom of the form to print the record (via a report)

If I base this on a record that already exists, it works fine.
However,
If I have just entered the record the query the report runs off doesn't see the new record. To print that record I have to exit the completed record, then go back in to it and print.
My aim is to remove this additional part of the process, I'm sure it's something really simple, but can anyone help?

Many Thanks
Paul

 

[Rickster57]

printing

Before firing off the code to print did you try saving that record?

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

 

[Dougalsworld]

Thank you so much for the quick response.
I had tried various versions of the save command to no effect but this has workd perfectly, and my print and export report fuctions work perfectly.

Once again many thanks
Paul