Multi filter referencing field on form

[ECEK]

Just having trouble getting my filter to work:

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?

 

[sneuberg]

You need to concatenate Me.UserName into the string otherwise it will be literally Me.UserName instead of its valued. Assuming User is a text field this would be something like:

strMyLast = "Status <> 'Completed' And User = '" & Me.UserName & "'"

 

[Gasman]

Try strMyLast = "Status <> 'Completed' And User = '" & Me.UserName & "'"

 

[ECEK]

Thanks Guys
I tried Gasman's solution and it works perfectly.
Many thanks.

 

[Gasman]

Thanks Guys
I tried Gasman's solution and it works perfectly.
Many thanks.

Sneuberg replied first, and my reply is the same as his?

 

[ECEK]

I just happened to try yours first and it worked ! I didn't need to compare.