Inserting expression into a query

[John]

Hi

I am using a form field as criteria in a query like this
[Forms]![MyForm]![MyField]. This works fine if the field has a single value
like "value1" but if the field has an expression as a value like "value1 or
value2" then the query returns nothing. Is there a way to insert the literal
value of the field "value1 or value2" into the query? I want to do it in a
way that I can change this expression at runtime.

Thanks

Regards

[Larry Linson]

Answered in the sponsored newsgroups. If you feel _compelled_ to post the
same question to multiple newsgroups, please crosspost so the answers will
show up in the newsgroup with the copies of the question. This one was
_multiposted_ separately, so there is no link from that answer to the
question here.

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:40***********************@news-text.dial.pipex.com...

Hi

I am using a form field as criteria in a query like this
[Forms]![MyForm]![MyField]. This works fine if the field has a single value like "value1" but if the field has an expression as a value like "value1 or value2" then the query returns nothing. Is there a way to insert the literal value of the field "value1 or value2" into the query? I want to do it in a
way that I can change this expression at runtime.

Thanks

Regards