wildcard search is query

[Guest]

I have a query set to prompt the user for input, it searches 2 fields and
then pulls up the record. I am wondering how I can get it so you can only
type part of the word and have it pull up any record containing what was
typed.

Thanks!

 

[Lynn Trapp]

Put something like the following in the criteria:

Like "*" & [Enter Some Part Of A Word] & "*"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html