 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Filter one combobox based on another combobox selection
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? Search on "cascading combo boxes" for more information on how to do this.  SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > I had 2 tables, called ProdInfor1 n ProdInfo2. Both are linked by Product > Code. Info1 contains the Product Item and Info2 contains the Size. [quoted text clipped - 9 lines] > 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? I'd browsed thru' the threads and I still can't find a solution to my problem. Any other ways you may help? > Search on "cascading combo boxes" for more information on how to do this. > [quoted text clipped - 17 lines] > 1 > > becos they have different sizing. How shld I limit it to 1 item? 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." SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > I'd browsed thru' the threads and I still can't find a solution to my > problem. Any other ways you may help? [quoted text clipped - 24 lines] >> 1 >> > becos they have different sizing. How shld I limit it to 1 item? Go to Google.com. Type in "Cascading Combo Boxes". Search. SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > I'd browsed thru' the threads and I still can't find a solution to my > problem. Any other ways you may help? [quoted text clipped - 20 lines] > > 1 > > > becos they have different sizing. How shld I limit it to 1 item? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.