GingGangGoo
Registered User.
- Local time
- Today, 03:15
- Joined
- Dec 14, 2010
- Messages
- 121
I have a form called ContactList that I would like to filter by contact's position. I have an unbound form with a combo box on it for choosing the position I want to filter by. I pointed to this combo box in the criteria on my query.
When I make a selection in the combo box and click ok, the query runs but it returns a blank datasheet. If I go into the query and put in the criteria and run the query, I get the contacts I want, but it's not reading what I've chosen in the combo box and filtering for that. What am I missing? The position field in the query on which I have my criteria is a multivalue field, if that makes a difference.
Help
TIA
When I make a selection in the combo box and click ok, the query runs but it returns a blank datasheet. If I go into the query and put in the criteria and run the query, I get the contacts I want, but it's not reading what I've chosen in the combo box and filtering for that. What am I missing? The position field in the query on which I have my criteria is a multivalue field, if that makes a difference.
Help
TIA