Can I use a drop-down field in a query so I can select a specific.

P

pscoffman

I want to use a drop-down (or "lookup") field in a query so I don't have to
type my select criteria exactly (ie name in a database).
 
R

Rick B

You would need to create a form with that drop down then call your query
from the form.

You could also allow the user to be less specisfic by using "like" in your
criteria...


Like [EnterPartOfName] & "*"


This would let you enter Smit and get all the results that start with
"smit"


For anywhere in the string, use...


Like "*" & [EnterPartOfName] & "*"


Hope that helps,

Rick B
 
Top