By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,078 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,078 IT Pros & Developers. It's quick & easy.

NoData for forms

P: n/a
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?
Feb 22 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Feb 22 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.