I have a Form that passes criteria to an underlying query which is the source for a Report. The user enters the desired criteria and then clicks on the "View Report" button. Prior to opening the report, I am wanting to enter code on the Form
module to test to see if there are any records to be returned. If the record count is 1 or greater I want the report to open. If there are no records that meet the given criteria then I want to do something else. How do I capture the number
of records in the underlying query of the report?
thanks.
...
Go to the complete details ...