Create error message for form search results being Null

[IT_Group]

I have a form and when it's opened you get 3 different search questions to answer or leave blank. My question is.... If a search parameter is entered but no results are found to match it, how do I create an error message telling the requestor "No Data Found"?

Thank You.

[orange]

Something like this maybe

If len(Result & "") = 0 Then
Msgbox "No data found !"
End if

[IT_Group]

Thank you for this info! Would you please tell me where I need to add it to make it work, in the query or form or table?

[orange]

How do you

If a search parameter is entered

and how do you start the search?
How do you test the result of the Search?

[IT_Group]

A table links to a query and the query links to a form.

In a query --
One of the 3 search fields example
Field: Birthday
Table: Copy Of Data_Info
Sort: Ascending
Show: "blank"
Criteria: Like [Enter DOB mm/dd/ccyy format] & "*"

When the form is opened the "Enter Parameter Value" window opens requesting the user "Enter DOB mm/dd/ccyy format" I put in a birthdate and either I see records populate this form or the form comes up with the fields being blank.

[orange]

Watch this free video about search.

http://www.datapigtechnologies.com/f...earchform.html

also what does this mean

Table: Copy Of Data_Info

[IT_Group]

After watching the video I think I maybe going about this the wrong way. It was very helpful and educational.


Table: Copy of Data_Info defines the name of the table I'm pulling the data from using the query.

Thank you for all your help!

[orange]

You are welcome. There are many free videos on Datapig---and you can always go back and watch them again.

I will mark this thread Solved.