Comparison operators in a combobox to filter a Form

[Falcon88]

all dears
hiii

i have a form that i want to use Comparison operators that is in a acombobox to find the criteria in [TextToComp] by choose the [TextServic] is a combobox of the fields of "tblOrders" .


Can you guide me how to do it. ?

 

[llkhoutx]

I tried to open your attachment, but couldn't. I get a message that it's a php file.

It's not clear to me that you mean by "comparison operator."

Forms can be filtered by modifying the reocrd source or by setting the form FilterProperty and the For FilterOn property.

Either method, you build SQL string. Your "conparison operator" is a component of that SQL.

 

[Falcon88]

it is not exactly filter .

it is a search .
here my attach. with

 

[spikepl]

I m guessing you are trying to feed operators into a query. You cannot - only values. Rewrite the query on the fly or construct logícal conditions that allow selection of a condition with the desired operator.

(If someone comes along and suggests using Eval tell him you do not need weird access-specific tricks)

 

[Falcon88]

After many attempts I am guided to some tricks, by using Select case.
There are some errors in the code. That need some adjustments.