A
alex
Hi,
i have a subform with combo boxes which builds a filter
string on a parent form (default view: single form) to
reduce the number of records which can be navigated in the
parent based upon the data selected.
When this is executed the parent shows at the bottom of
the form, for example,
"Record |<< 1>>| of 4 (filtered)"
of which there would be 50 unfiltered records in total.
When there are no results for the selected criteria a
blank form (completely empty of everything) is displayed.
To prevent this i want to "me.filteron = false" IF the
number of recs = 0
If the form knows how many filtered recs there are what
function can i use to determine this myself and stop the
blank form?
i have a subform with combo boxes which builds a filter
string on a parent form (default view: single form) to
reduce the number of records which can be navigated in the
parent based upon the data selected.
When this is executed the parent shows at the bottom of
the form, for example,
"Record |<< 1>>| of 4 (filtered)"
of which there would be 50 unfiltered records in total.
When there are no results for the selected criteria a
blank form (completely empty of everything) is displayed.
To prevent this i want to "me.filteron = false" IF the
number of recs = 0
If the form knows how many filtered recs there are what
function can i use to determine this myself and stop the
blank form?