Query not showing results from combo box

[Rushman21]

Access 2010. This has worked before but I don't understand why this is not working for me now. When i select an item in a combo box in a form and click on a button to run a query with the results, the query is blank. If I run the query alone, it prompts for an item, I can type it in and it works. I have even tried the DoCmd on the combo box but still same results. Attached is a dummy down DB. If you run the query, it will prompt, select Paper or Rock, see results. But run the form, the drop down will not show the results. What am I missing?
Thanks for your help.

 

[pbaldy]

Because the bound column of your combo is the ID field (1 or 2).

 

[Rushman21]

Yup! I just figured that out myself and was ready to delete this thread. Wonder if I should keep this up here for future reference?

Thanks a lot!

 

[pbaldy]

Typically we leave threads so that someone searching for an answer later may be helped by this one.

Happy to help!