G
Guest
I have a user input form for generating a report. The selections the user
makes get passed via global variables to the report. The report's open
event, among other things, is where the RecordSource query is built for the
report. Certain combinations of user input can produce an empty set of
records. How do I check for this condition so that I can gracefully warn the
user of the condition and close the report?
The following construct (in the report's open event) is not valid:
If Me!RecordSource.EOF and Me!RecordSource.BOF then ...
makes get passed via global variables to the report. The report's open
event, among other things, is where the RecordSource query is built for the
report. Certain combinations of user input can produce an empty set of
records. How do I check for this condition so that I can gracefully warn the
user of the condition and close the report?
The following construct (in the report's open event) is not valid:
If Me!RecordSource.EOF and Me!RecordSource.BOF then ...