Making a combo visible depending on the selection of another combo

[Diezz]

Hello,

I have 2 combo box, 1: cboTypePb, 2: cboMVS. The second combo box has .visible = false. I want it to turn true for a certain record in the first combo so this is what i've done.

Private Sub cboTypePb_Change()
If cboTypePb.Value = "Applications MVS" Then
cboTypePb.SetFocus
[MVS Application_Label].Visible = True
cboMVS.Visible = True
chkExplicationMVS.Visible = True
Else
cboTypePb.SetFocus
[MVS Application_Label].Visible = False
cboMVS.Visible = False
chkExplicationMVS.Visible = False
End If

This dosen't work, do you have any ideeas?

Thanks

 

[Remou]

I think you should do this in the After Update event.

If cboTypePb is based on an ID and a Description, it is quite likely that it is equal to say, 1, rather than "Applications MVS". You can use a message box to test.

I do not think you need the Set Focus lines.

 

[Diezz]

That worked, pf i don't know what i would do without this Forum.

Thanks alot!