Just having trouble getting my filter to work:
Im trying to filter my form by everything not completed and by the a field called userName that appears on my Form.
Any ideas?
Code:
Dim strMyLast As String
strMyLast = "Status <> 'Completed' And User = Me.UserName"
Debug.Print strMyLast
Me.Filter = strMyLast
Me.FilterOn = True
Im trying to filter my form by everything not completed and by the a field called userName that appears on my Form.
Any ideas?