NoData for forms

[Jimmy]

Is there a way to check if there are no records in a filtered form and
display an error message such as can be done using the NoData event for a
report?

[fredg]

On Thu, 22 Feb 2007 01:34:01 GMT, Jimmy wrote:

Is there a way to check if there are no records in a filtered form and
display an error message such as can be done using the NoData event for a
report?

Filtered how?
Is the form's record source a filtered query?
Do you mean when you open the form?
Code the Form's Open event:

If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "No Records found."
Cancel = True
End IF
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail