Access Report Printing Completed

[kennedymr2]

Vba Code..

Is there code to determine if an access report has been completed.

Ie hold up code in a Sub until report is completed


Appreciate any help

 

[zevw]

You can see if a report is open and then run code. Which would essentially happen one you execute code to open a report.

Lets say you report name is "TEST REPORT"

    Do while Reports.Count = 0
       Flag = ""
    Loop


    For cnt = Reports.Count To 0
        RptName = Reports(cnt).Name
        If RptName = "TEST REPORT" Then
           'execute you code here
        End If
    Next