Combo Box

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

Guest

I have two bombo boxes. If value "XXXXXX" is selected in combo box 1 I would
like combo box 2 to default to "YYYYYY" while still giving the user the
ability to select other values from combo box 2. Each Combo Box gets its
selection from a different table
 
Hey Rafi,

If you do a search on "Cascading Combo Boxes" or something like this, you
should find plenty of resource on how to do what your looking for.

HTH,
Shane
 
you could try a select case in combo1's after_update like:

Combo1_AfterUpdate()
Select Case Combo1
case this
combo2 = something1
case that
combo2 = something2
case theother
combo2 = something3
end select

End Sub
 
Back
Top