Web Development·12,052 discussions

Counting Records (Form and Report)

Locked

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.

Topic

Counting Records (Form and Report)

In reply to Counting Records (Form and Report)

Hi,
To do that, use the RecordSetClone property of the form or report. Use it on the On Open event for both objects.
Ex: If Me.RecordSetClone.RecordCount > 0 Then
Do something
End If

Christian

[Author]

Replies