Query promting for search criteria

A

amy ratcliffe

Hi, I need my query to prompt the user to type what they are looking for as
criteria. I have done this before by typing the message for the criteria
promt in speach marks such as: "Please Type Name" but this doesnt work i
think i need to type a word before it but i cant remember what it is, does
any one know?
 
R

Rick B

Or to find anywhere in the field...

Like "*" & [please type partial name] & "*"

This will also allow them to leave it blank for "all".
 
Top