J junmart Registered User. Local time Today, 04:00 Joined Sep 14, 2001 Messages 29 Sep 20, 2001 #1 i have a query in which user's are required to input a parameter. how do i create a message "no record found" when there are no hits found based on the parameter entered? thank you in advance for your help!
i have a query in which user's are required to input a parameter. how do i create a message "no record found" when there are no hits found based on the parameter entered? thank you in advance for your help!
J junmart Registered User. Local time Today, 04:00 Joined Sep 14, 2001 Messages 29 Sep 20, 2001 #3 yes i am using a form to diplay my query....
Travis Registered User. Local time Yesterday, 20:00 Joined Dec 17, 1999 Messages 1,332 Sep 21, 2001 #4 After you requery your form. Check the Me.RecordSetClone.RecordCount Property. It will be a number Greater then Zero if there are records and Zero if there are no records.
After you requery your form. Check the Me.RecordSetClone.RecordCount Property. It will be a number Greater then Zero if there are records and Zero if there are no records.
