combo box based on text box value

  • Thread starter Thread starter val
  • Start date Start date
V

val

I have a form with two combo boxes. First combo box
retrieves selected record. I would like second combo box to
retrieve based on value in a text box. If text box value
is red then combo box would show all red items. If text box
value is blue combo box would show blue items. I searched
for answer but, must be phrasing something wrong as I got
no results. If someone could point me in the right
direction I would appreciate it. Thank-You
 
Val

The second combo box is based on a query, right? In the query, use an
expression for the "color" field criterion that points to the form/control
that holds the color ... something like:

Forms!YourFormName!txtYourColorTextName
 
Thanks Jeff, I was incorrectly "phrasing" my query. Your
expression helped me get it correct.
 
Back
Top