sql string

[doodle]

Access 97, win xp

This code is located in my main switchboard. I need to change
[Customer] to a variable named y, but I can't get the quotes right.

Here is the original line:
DoCmd.OpenForm myFrm, WhereCondition:="[Customer] Like ""*" & x & "*"""

Here is what I tried: (Which returns a type mismatch)
DoCmd.OpenForm myFrm, WhereCondition:=y & " Like " * " & x & " * """"""


any help would be greatly appreciated.

-doodle

 

[doodle]

I figured it out:

DoCmd.OpenForm myFrm, WhereCondition:=y & "Like ""*" & x & "*"""