Search Form with Combo Box not pulling up

[wnicole]

Can you help?


I have pic of my query attached(the last one one right is my state). I have a Search Form...however when I go to Search for State which is a combo box (drop down) it doesn't give me any results.
Is there something different I need to do for a combo box versus just txt.

Please see code and let me know if this is the correct one. Appreciate your help

.

[alansidman]

You probably have to bring in the table that is your lookup for the combo box and then add the appropriate field to the grid. Next you will need to uncheck the cooresponding field in your query. Keep it in the grid but not visible. Your query is looking at the name in the combo box while your main table probably has a number for the bound column in your look up table. Join the lookup table to the main table.