Filter combo 2 based on combo 1

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I've done this before, but can't for the life of me
remember exactly how.

On a form,
combo box 1 lets the user select a TYPE. Based on the
type, various products are available.

combo box 2 displays the PRODUCTS available for that TYPE.

On the control source of combo2, I've tried:

SELECT qry_PRODUCTS.PRODUCT_DESCRIPTION,
qry_PRODUCTS.PRODUCT_ID, qry_PRODUCTS.TYPE_ID FROM
qry_PRODUCTS WHERE qry_PRODUCTS.TYPE_ID=[TYPE_ID];

Any suggestions on making this work?

Thank you, Ron.
 
You must log in or register to reply here.

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

Filtering combo based on previous combo 3
Requery Form from Combo Box 3
Combo box help 1
1 combo box changes per 2 other combo boxes 3
filter query on combo box in a continuous subform 0
sum combo box based on other combo box 2
combo box choices based on first combo box 7
Combo Box Filter 1

Back
Top