This is lboEvent:
This is the query that gives me the info therein:
Design view:
Datasheet view:
The first 2 columns in the query are not visible. It starts with the column "EventStatusDisp." I'm trying to write code that tells it that if EventStatusDisp is NM, LC, or EC, then it is Visible = False.
This is the code I wrote:
Private Sub lboEvent_AfterUpdate()
If EventStatusDisp = "NM" Or "LC" Or "EC" Then
Visible = False
End If
End Sub
Clearly, I did it wrong, since the NM's and what not are still visible.
Any suggestions?
Thanks.