CHANGING ITEMS IN COMBO BOXES

  • Thread starter Thread starter BRENNON
  • Start date Start date
B

BRENNON

I would like to have one field dictate the options/list
in a combo box. For instance... If I chose a specific
position in one combo box i.e. If i choose the state of
PA in one combo box... I only want to see cities in the
state of PA in a corresponding combo box.

In other words... one combo box is dictating the options
in a different combo box.

Any thoughts or ideas about how I might be able to do
this?
 
I would like to have one field dictate the options/list
in a combo box. For instance... If I chose a specific
position in one combo box i.e. If i choose the state of
PA in one combo box... I only want to see cities in the
state of PA in a corresponding combo box.

In other words... one combo box is dictating the options
in a different combo box.

Any thoughts or ideas about how I might be able to do
this?
Click to expand...

Set the dependent combo's RowSource query to use the main combo as
criteria. In the AfterUpdate event of the main combo requery the
dependent combo boxes.

- Jim
 
Back
Top