Values in Combo Boxes returning a value in another one.

[JesseL]

Hello..

I have a combo box that has 5 values. If the value "WCDH" is selected from the list, it should AUTOMATCIALLY return a value of "empty" in another combobox. "empty" is not a value in the pull down in the other combo box. Is this a problem?

Can i get a simplistic example please?

thanks
ksharp

 

[JesseL]

here is the code: It doesn't work, Can someone tell me what i am doing wrong?

Private Sub cboUnitDescriptionID_AfterUpdate()

If Me.cboUnitDescriptionID.Value = "WCDH" Then
Me.cboSwingID = "-"
Exit Sub
End If

If Me.cboUnitDescriptionID.Value = "Casement;Door" Then
MsgBox "The Swing type must be entered"
Exit Sub
End If

End Sub

 

[SBendBuckeye]

I'm not sure what you mean by empty. Do you mean with no value selected so it appears empty? If that is what you are trying to do then you can set cboOtherComboBox = 0. You can also move focus to the other control by doing cboOtherComboBox.SetFocus in the code.

Hope this helps! Good Luck!

 

[JesseL]

Yes.. I should of elaborated just a little more.. Not meaning empty, as in null. I mean have the text "Empty" in combo box2 when combo box1 is a certain value that the user chooses.

 

[SBendBuckeye]

Since you don't actually want a value in the second combo box, maybe a better solution would be to disable it for certain situations. Perhaps something like the following:

If Me.cboUnitDescriptionID.Value = "WCDH" Then
Me.cboSwingID.enabled = False
Exit Sub
End If

You could then re-enable it in the FormCurrent code.