Filter one combobox based on another combobox selection


G

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?
 
Ad

Advertisements

G

Guest

I'd browsed thru' the threads and I still can't find a solution to my
problem. Any other ways you may help?
 
Joined
Jun 23, 2007
Messages
61
Reaction score
0
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... :confused:
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".
 
Last edited:
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."
 
Ad

Advertisements

Ad

Advertisements


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

Top