Combo Box

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

Rafi wrote:
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

--
Message posted via http://www.accessmonster.com

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

--
Kelly D

Message posted via http://www.accessmonster.com