Counting Records (Form and Report) - TechRepublic
General discussion
January 30, 2002 at 01:58 PM
shanghai sam

Counting Records (Form and Report)

by shanghai sam . Updated 24 years, 5 months ago

Depending on whether the user wants to view results of a custom query in a report or form, I am opening the report or form with a filter string with the Docmd.OpenForm function.
How do I detect whether the form or report will contain any records after the filter is applied?
I want to msgbox the user if no records will be returned.

This discussion is locked

All Comments