Maybe no one understood what I was asking before, so let me try this again:

In this example:

recordset.Find "FIELD = 'MyVar'"

What is the correct syntax for replacing the literal string, "MyVar," with a
variable?
I've tried every way I could think of, and I always get a syntax error as
the result.

For instance:

Dim MyVariable as String
recordset.Find "FIELD = MyVariable"

does not work.

TIA,
Mike