Only allow values dependant on other box

[AussieGal]

Hi,



I have a form that has combo that should only be able to be entered into dependant on another combo box's value.
eg If users select 514 from the first combo (cmbProCode), then they can enter into CoStaff field which is also a combo box. I want it so if 514 is not in the cmbprocode field, then costaff should be blank. I am fine with a message box popping up if this criteria is not met, yet I was trying with enabled and wasn't getting far. These combo boxs are on a continuous sub form.

This is what I was trying, without success.

Private Sub CoStaff_BeforeUpdate(Cancel As Integer)
    If Me.cmbProCode.Value = 514 Then
        Me.CoStaff.Enabled = True
        Else: Me.CoStaff.Enabled = False
    End If
End Sub

[June7]

Setting this property by code will affect all instances of the control.

Enabled state can be managed with criteria in Conditional Formatting.