Query to pull records based on Combo Box Selections

R

Robert Ross

I need a query to pull records based on the selection (or
selections) in a combo box on a form. I've tried to have
the criteria for the query in the QBE grid read:
[Forms]![FormName]![Combo1]
but it doesn't work.

Does anyone have any ideas?

THX!
 
K

Kelvin

This should work if the form is open. Keep in mind that combo boxes store
the bound column which may not necessarily be what is shown. So if yous
criteria is checking for what is shown, this won't work. Move the criteria
to the correct field or change the current criteria to
Forms![FormName]![Combo1].Column(X), where X is the column number-1.

Kelvin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help making query with criteria based on combo box selections 18
Pull criteria from a Form 2
IIf statement in query criteria 5
passing a parameter based on multiple selections 7
How to use dropdown selections on a form to pass into a query 6
Default Query Criteria 1
query based on combo box on form not working. Coming back blank 1
Combo Box in a Query 3

Top