Interactive Combo Boxes

  • Thread starter Thread starter Matthew David
  • Start date Start date
M

Matthew David

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.
 
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.
 
Thanks!
Douglas J. Steele said:
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.
Click to expand...
 
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
 
Back
Top