How to make the Operator a Variable?

First and foremost I do not have the experience to code in VB, so if possible
please limit your responses to using the GUI.

I have a query that I am trying to run that uses form data as selection
criteria. i.e. [Forms]![Data]![ClientID], etc. I am trying to set the
Operator for this criteria as a variable so that I could make it =//like
etc. This does not appear to be working as the results always come back
blank. Is there a way to create an operator variable? I searched the web
but found no information, likewise with this forum.

My end result would be to have two variables, pulled from two data fields
entered in a form, in the same selection criteria box. (One would be the
operator and the other would be the list of values.)

[Forms]![Data]![ClientOperator][Forms]![Data]![ClientID]

Any assistance you could provide would be appreciated.

Short answer is no.

Long answer requires VBA.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

"CaptainMyCaptain" wrote in
message ...
First and foremost I do not have the experience to code in VB, so if
possible
please limit your responses to using the GUI.

I have a query that I am trying to run that uses form data as selection
criteria. i.e. [Forms]![Data]![ClientID], etc. I am trying to set the
Operator for this criteria as a variable so that I could make it =//like
etc. This does not appear to be working as the results always come back
blank. Is there a way to create an operator variable? I searched the web
but found no information, likewise with this forum.

My end result would be to have two variables, pulled from two data fields
entered in a form, in the same selection criteria box. (One would be the
operator and the other would be the list of values.)

[Forms]![Data]![ClientOperator][Forms]![Data]![ClientID]

Any assistance you could provide would be appreciated.