R
Richard
What I want to do is open a report, and immmediately after
opening it, check to see if there is any data in the
report. I can sucessfully open the report from VBA, but
when I add in the If statement that checks for a NoData
situation I get the error:
Run-Time Error '2451'
The report name 'Monthly Branch Report' you entered is
misspelled or refers to a report that isn't open or
doesn't exist.
How can this be? I opened the report in the previous line
of code. Here is a snippet of the code...
DoCmd.OpenReport "Monthly Branch Report",
acViewNormal, , "[brancd]=" & rst!Branch
If Reports![Monthly Branch Report].NoData = False Then
<<perform operation>>
End If
Any suggestions would be much appreciated. Thanks.
opening it, check to see if there is any data in the
report. I can sucessfully open the report from VBA, but
when I add in the If statement that checks for a NoData
situation I get the error:
Run-Time Error '2451'
The report name 'Monthly Branch Report' you entered is
misspelled or refers to a report that isn't open or
doesn't exist.
How can this be? I opened the report in the previous line
of code. Here is a snippet of the code...
DoCmd.OpenReport "Monthly Branch Report",
acViewNormal, , "[brancd]=" & rst!Branch
If Reports![Monthly Branch Report].NoData = False Then
<<perform operation>>
End If
Any suggestions would be much appreciated. Thanks.