G Guest Oct 7, 2004 #1 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).
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 Oct 7, 2004 #2 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
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
