Field Refresh

[jen]

I have two combo boxes, Field A and Field B.

When I select am item in Field A, Field B updates, dependant on Field
A. I have this working correctly, however, I'm getting stuck on the
display of Field B. For example, I select Apples from Field A, and
then choose Red in Field B. Then I change my mind and want to select
Oranges in Field A, so I do so. When I select the dropdown in Field B,
Orange is there, yet Red is showing in the Combo Box itself.

Is there any way to refresh this so my user can't select Red Oranges?
Thanks in Advance!

[Bilk Whitey]

"jen" <je*******@gmail.com> wrote:

When I select am item in Field A, Field B updates, dependant on Field
A. I have this working correctly, however, I'm getting stuck on the
display of Field B. For example, I select Apples from Field A, and
then choose Red in Field B. Then I change my mind and want to select
Oranges in Field A, so I do so. When I select the dropdown in Field B,
Orange is there, yet Red is showing in the Combo Box itself.

Is there any way to refresh this so my user can't select Red Oranges?

You could have some code in the first combo box's On Change event which
sets the contents of the second to a zero-length string, something like:

Private Sub cboMyCombo1_Change()

Me.cboMyCombo2 = ""

End Sub

This will blank out combo 2 every time a new value in combo 1 is selected.

HTH - Keith.
www.keithwilby.com