Query not working with criteria Like or Not Like

[jtan]

I've a query which the user needs to select a button for the location (GDC or Others) in the interactive form :



When GDC button is clicked,
Private Sub GDC_Click()
Me!location = "Like " & Chr(34) & "*GDC*" & Chr(34)
DoCmd.OpenQuery "queryname"
End Sub



When Others button is clicked,
Private Sub Others_Click()
Me!location = "Not Like " & Chr(34) & "*GDC*" & Chr(34)
DoCmd.OpenQuery "queryname"
End Sub



Query


But the query not working. Please help.

[Welshgasman]

Not sure why you are using Chr(34)?

Why not

Me!location = "Like *GDC*"

as you are not using any sort of variable?

[jtan]

I'd also used
Me!location="Like *GDC*"
But, query also not working

[NoellaG]

Try Me!location = "Like ""*GDC*"""

[Minty]

I think you approaching this all wrong.
Put the Like expression in your query directly and remove the need for the complex formatting?

Something like

SELECT * FROM YOUR TABLE 
WHERE MyField Like "'*" & Forms!YourForm!YourSearchField & "*'"

[CJ_London]

You cannot use query parameters in a criteria in that way

you can use the eval function something like

expr1: eval([myfield] & forms!myform!myfield)
and set the criteria =true