How do you make multiple lists in a combo box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is what I want to do. Say you have your typical combo box with limited
selections based on a row source or even custom source. These are based on
regions Central,East,Mid-America,South and West. Lets say if you highlight
West in the combo box, then seperate areas there would appear like
Washington,Oregon,California etc...Basically the same way the start menu
operates on windows. Is there a way to do this?
 
Here is what I want to do. Say you have your typical combo box with limited
selections based on a row source or even custom source. These are based on
regions Central,East,Mid-America,South and West. Lets say if you highlight
West in the combo box, then seperate areas there would appear like
Washington,Oregon,California etc...Basically the same way the start menu
operates on windows. Is there a way to do this?
Click to expand...

The simplest way is to use two combo boxes, one for region, one for
area. The area (state?) combo would be based on a Query using

=Forms![yourformname]![cboRegion]

as a criterion to filter the records to just that region. You'll need
one line of VBA code in the afterupdate event of the Region combo box
(which I'm calling cboRegion):

Private Sub cboRegion_AfterUpdate()
Me!cboArea.Requery
End Sub

John W. Vinson[MVP]
 
Back
Top