If Statement

[DJ_DEF_CON_1]

I have a hidden form with a text box field that I am trying to query. The following is giving me problems. Any ideas?

If Forms![SCRATCH_PAD]![tbxUSER_ID] = 'DELUCAK' Or 'MOULTONM' Or 'ROBERTSD' Or 'SCALFD' Then

When I select the command button that has the above as an event procedure, I get a syntax error.

 

[Mile-O]

If Forms![SCRATCH_PAD]![tbxUSER_ID] = 'DELUCAK' Or Forms![SCRATCH_PAD]![tbxUSER_ID] = 'MOULTONM' Or Forms![SCRATCH_PAD]![tbxUSER_ID] = etc.....



Too long

Select Case Forms![SCRATCH_PAD]![tbxUSER_ID]
    Case Is = DELUCAK, "MOULTONM", "ROBERTSD", "SCALFD"
        ' do something
    Case Else
End Select

 

[DJ_DEF_CON_1]

Thanks - I learned something new. I appreciate the help.

If Forms![SCRATCH_PAD]![tbxUSER_ID] = 'DELUCAK' Or Forms![SCRATCH_PAD]![tbxUSER_ID] = 'MOULTONM' Or Forms![SCRATCH_PAD]![tbxUSER_ID] = etc.....



Too long

Select Case Forms![SCRATCH_PAD]![tbxUSER_ID]
    Case Is = DELUCAK, "MOULTONM", "ROBERTSD", "SCALFD"
        ' do something
    Case Else
End Select