New record after report preview

[Tupacmoche]

Hi VBA Masters,


I have a button with the code DoCmd.OpenReport. This command is in a case statement that print/opens the appropriate report based on some conditions. In any event what, I need help with is code that will run after exiting the report preview. This is the code: DoCmd.GotoRecord, , acNewRec. Basically, after exiting the report preview, I want to start a new record and not go back to the record that, I was previewing. How can this be accomplished?

 

[pbaldy]

Untested by try adding that line after OpenReport, but add the acDialog argument to the OpenReport. That will make the code pause and wait for the report to be closed.