on close propertz in code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a code in Access.
My desired sequence is
1.open a query
2. open two reports
3.review the reports + close the reports
4. decide whether to accept changes

Problem is that immediately after opening of reports Message box is coming,
/basically action no 3 performed t the end/
And there is no chance to review reports(they are in background).

I am looking for some kind of property „On Close Report“ or other solution
Which assure that when the reports are closed, next action can start.

Many Thanks
Stefan889-12

Example of code:
DoCmd.OpenQuery "P010EWTU create to NEW", , acReadOnly
DoCmd.RunMacro stDocName1 ' opens two reports
response = MsgBox("do you accept changes?", style, "change of tubes")
 
Reports are for printing, not for displaying on screen. You need to use a
form instead.
 
Back
Top