Query promting for search criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Or to find anywhere in the field...

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

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