using applyFilter with a variable

[Jo-Anne]

I am trying to apply a filter to a form based on a parameter passed through
the openArgs function. The issue arises when I use the applyFilter function.

Here is the code:

If Not IsNull(Me.OpenArgs) Then
Dim memberID As String
memberID = Me.OpenArgs
DoCmd.ApplyFilter , "memID = memberID"
End If

The problem lies in the memberID variable. If I enter a memberID value the
filter works properly. I'm sure it is a simple problem with quotes or
something having to do with recognizing variables.

Any help would be great.

 

[Jo-Anne]

Thanks for your help. Works great now!

memberID being a variable needs to be outside any quotes. Enclosed in
quotes, it is seen as a literal string.

If memberID is a string:
DoCmd.ApplyFilter , "memID = '" & memberID & "'"

If memberID is a number:
DoCmd.ApplyFilter , "memID = " & memberID