Search criteria with no text.

[kp1279]

I have created a search criteria in a field, I have used:

' Like "*" & [text] & "*" '

If I put in 'LON' it will return entries that include text like 'LONDON' 'LONGTON' etc.

If I leave the text blank, and just click OK then it will bring back all entries, how can I change it so that if the user doesn't enter a search criteria, then it will not bring back any result, or promt for a criteria?

KP

 

[PHV]

WHERE ...
([yourField] Like '*' & [text] & '*' And Trim([text] & "")<>"") ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kp1279]

Worked great.

Thanks for another solution.

KP