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.
 
Back
Top