Check for data prior to opening report

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

Guest

Hello,

I assume this is relatively basic, but I want to check the underlying query
of a report for data prior to opening the form. What is the best way to do
this assuming I have a button with the following underlying code:

dim stRepName as String
stRepName = forms!dlgReports!txtRepName
docmd.OpenReprt "stRepName"

I am trying to avoid errors in the report's OnFormat event, and also to stop
the report's OnClose event from executing.

Thanks
 
Note that there's a typo in that first sentence. It should read:

I assume this is relatively basic, but I want to check the underlying query
of a report for data prior to opening the REPORT (or IT would do as well)

I've been working with Access for so long I can't believe I made such a
fundamental error...
 
Back
Top