Selecting an item in a combobox...in Access

[Laurel]

Is there any way to force the selection of one combobox when another is clicked?

What I'm trying to do is have the user select an item in a combobox and have the OTHER combo box automatically revert to .ListIndex(0) when the first combobox is clicked. You can do this in VB by just setting the .ListIndex property but you can't do this in Access. Anybody have any suggestions?

L

[kashif_82]

In your form, have you second dropdownlist change its value depending on the first dropdown (did this a long time ago when learning ACCESS), I dont exactly remember how to do that but it is doable. then make your second dropdown required in the table which will automatically make the second one required.

[Laurel]

I dont exactly remember how to do that but it is doable

Yes, well, that's the part I NEED!

I've been an Access Programmer for a long time....but more recently a VB programmer. Sometimes I like VBA a LOT better than straight VB but TODAY I like VB better!

L

[Gorthog]

You are on the right track, but the combobox properties are different for VBA. Try the following:

Private Sub cboTest1_AfterUpdate()

    Me!cboTest2.Value = Me!cboTest2.ItemData(0)

End Sub

After the first combobox (cboTest1) is updated, the second combobox (cboTest2) will automatically change to the first value (index 0) in its list.

[Laurel]

ME LOVES THE GORTHOG!


Thanks, EVER SO MUCH, gorthog! I tried all SORTS of combinations of things but just couldn't get the **** thing to work!

L