Filter one combobox based on another combobox selection

C

confu-sed

I had 2 tables, called ProdInfor1 n ProdInfo2. Both are linked by Product
Code. Info1 contains the Product Item and Info2 contains the Size.

So I have this form, frmProductDetails which I would like to search for the
products using 2 combo boxes, which the first 1 is to select the product that
I want and subsequently I will want the 2nd one to filter out the sizes that
this Product has. And these 2 combo boxes are to appear in the form itself.

I came across 1 good example at http://www.databasedev.co.uk. However, it is
not within the form itself.

And with that, I realized that the same items have shown up in the Combox 1
becos they have different sizing. How shld I limit it to 1 item?
 
C

confu-sed

I'd browsed thru' the threads and I still can't find a solution to my
problem. Any other ways you may help?
 
D

Douglas J. Steele

To limit the items in the combo box, use SELECT DISTINCT in your SQL, rather
than simply SELECT.

You'll have to provide more details about what you mean by "However, it is
not within the form itself."
 
Top