Parameter query help 1

[WallT]

I have a query I use to locate a customer by entering 1 or more letters in a parameter as follows. My question is, when the user just hits enter without entering a parameter it will bring up every customer. This is well over a 100,000 records.

I would like the query to bring up nothing, or be able to put a Dialog box that says you didn't enter any characters. Here's what I use for this in the query criteria...

Like [Enter one or more letters of the Firm name] & "*

 

[PHV]

You may try this:
Like [Enter one or more letters of the Firm name] & "*" AND Len([Enter one or more letters of the Firm name] & "")>0

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[WallT]

Great...you have helped my project quite a bit today.