D
Dan @BCBS
Can I limit a specific value in a combo box.
Example: combo box = new, old, Withdrawn. Onl certain people should be able
to choose Withdrawn.
This is what I have, but the entire combo box is disabled (no values
display).
If glevel <> "MANAGER" Then
cmdDelete.Enabled = False
Me.TR_DECISION.RowSource = "SELECT DEC_CODE From tblDecisionCodes"
Else
Me.TR_DECISION.RowSource = "SELECT DEC_CODE From tblDecisionCodes
WHERE (DEC_CODE = 'WI')"
End If
////////////////////
Example: combo box = new, old, Withdrawn. Onl certain people should be able
to choose Withdrawn.
This is what I have, but the entire combo box is disabled (no values
display).
If glevel <> "MANAGER" Then
cmdDelete.Enabled = False
Me.TR_DECISION.RowSource = "SELECT DEC_CODE From tblDecisionCodes"
Else
Me.TR_DECISION.RowSource = "SELECT DEC_CODE From tblDecisionCodes
WHERE (DEC_CODE = 'WI')"
End If
////////////////////