junmart
09-20-2001, 08:25 AM
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!
|
View Full Version : help! junmart 09-20-2001, 08:25 AM 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! Rich 09-20-2001, 10:56 AM Are you using a form to display the results of your query? junmart 09-20-2001, 12:08 PM yes i am using a form to diplay my query.... Travis 09-21-2001, 09:55 AM 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. |