Me.Filter with variable woes

[chris.williams]

I am having a difficult time setting a filter criteria based on a text field entered prior to the filter being set and turned on.



Basically, the value of the variable is not being passed to the filter properly. In each instance, the MsgBox command validates that the proper value is set in the variable.

Here's my code with several attempted commands and their results:

    MsgBox "NUID: " & Me.TextLoginNUID, 0
            
'    Me.Filter = "[NUID] = " & "Me.TextLoginNUID"    ' This one seems to not error out - but prompts for Me.TextLoginNUID
        
'    Me.Filter = "[NUID] = 'P482017'"               ' This works properly - but without a variable

'    Me.Filter = "[NUID] = " & Me.TextLoginNUID      ' This one prompts for Me.TextLoginNUID but places the value of Me.TextLoginNUID in the title of the prompt
    
'    Me.Filter = "[NUID] = Me.TextLoginNUID"        'This prompts for Me.TextLoginNUID"
    
    Me.FilterOn = True
    Me.Requery

[pbaldy]

Since your value is text, try


Me.Filter = "[NUID] = '" & Me.TextLoginNUID & "'"

[chris.williams]

That did the trick. Thank you

[pbaldy]

No problem. That adds the apostrophes you had in your working example.