Query to pull records based on Combo Box Selections

  • Thread starter Thread starter Robert Ross
  • Start date Start date
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!
 
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
 
Back
Top