Filter Using VBA

[comfygringo]

Why doesn't this work? myUserID is a public variable.

Private Sub cmdCallback_Click()
Me.Filter = "[Valid_numbers].[Call Back] = True and [Valid_Numbers].[UserID] = '&myUserID&'"
Me.FilterOn = True
End Sub

[RuralGuy]

Try this:
Me.Filter = "[Valid_numbers].[Call Back] = True and [Valid_Numbers].[UserID] = '" & myUserID & "'"

[comfygringo]

Thanks! That worked!

[RuralGuy]

Great! Glad we could help.