 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / ActiveX Controls / January 2006Interactive Combo Boxes
I am working on an Access Form with a series of ComboBoxes on the screen. There are three main ComboBoxes that list Owner, Product and Color. What I am looking to do is to fitler the options in each ComboBox depending on your selection criteria. For instance, when you select Owner the number of products filter in the Product ComboBox to only those that the selected Owner has access to to. When an Product is select only the colors for the product are presented. Thanks for any help.  SignatureMatthew David PH: 920.475.2972 FAX: 775.239.8171 mdavid@matthewdavid.ws You need to put code in the AfterUpdate event of combobox 1 to dynamically generate the SQL for the row source of combobox 2. http://www.mvps.org/access/forms/frm0028.htm at "The Access Web" has an example of this. And, FWIW, this really has nothing to do with microsoft.public.access.3rdpartyusrgrp or microsoft.public.access.activexcontrol. The first is for questions about 3rd party controls or user groups for Access, and the second is for questions about using ActiveX controls in Access. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) >I am working on an Access Form with a series of ComboBoxes on the screen. > There are three main ComboBoxes that list Owner, Product and Color. What I [quoted text clipped - 6 lines] > > Thanks for any help. Matthew Follow this tip and it should provide you the guidance you need. Tip #16: Data in a combo box control on a continuous form/datasheet disappears http://www.fmsinc.com/free/tips.html#tip16foraccess HTH SignatureRob Mastrostefano FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com >I am working on an Access Form with a series of ComboBoxes on the screen. > There are three main ComboBoxes that list Owner, Product and Color. What I [quoted text clipped - 6 lines] > > Thanks for any help. You do not have to dynamically create the query. You can also have the query predefined for the 2nd combo box (pointing to the form![combobox1] as criteria) but in the afterupdate event of the first combo, issue a requery of the second combobox. Ron |
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
|
©2008 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.