Filter one combobox based on another combobox selection

[Guest]

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?

 

[Jeff Boyce]

Search on "cascading combo boxes" for more information on how to do this.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

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

 

[ajetrumpet]

This link has a very short page of instructions for this...
http://www.mvps.org/access/forms/frm0028.htm

This one is probably better though...I haven't seen a page that explains this task as well as this one does in a long time. This guy even explains the process and why you're doing it! So you aren't just copying instructions without understanding what you're doing...that's cool! It should really do the trick for you though...check it out! I don't know who this guy is either...
http://accessprogrammer.blogspot.com/2005/08/filter-combobox-based-on-another.html

I'd browsed thru' the threads and I still can't find a solution to my
problem

Amen...apparently people are getting sick of seeing this question on the forums, but noone has thought of a reason why it might be happening. I myself have found very few GOOD articles on this topic of cascading that can reach the knowledge base of a beginner in Access. It might seem simple...but obviously its not a "no-brainer".

 

[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."

 

[Jeff Boyce]

Go to Google.com. Type in "Cascading Combo Boxes". Search.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/