Write the criteria of a query in the event code

[Batraul]

Hi all!

Is it possible to write the criteria in a textbox and, depending if the first character is "<", ">", "=", etc, write a code in the event of this textbox which fills the criteria of that query through a variable or something like that?
Off course, to check if the first character is >< I would use function MID.


Thank you!

[June7]

AFAIK, operators (<,>,=, LIKE) in query criteria cannot be dynamic.

I don't use dynamic parameterized queries. I use code that applies filter to form or report. Review: http://www.allenbrowne.com/ser-62code.html

[orange]

It might be better for you and readers if you could tell us in plain English WHAT you are trying to accomplish. There may be options, but knowing WHAT is key.

[Batraul]

Ok. Sorry if I haven't explained well.
I wanted to upload the file but I've seen that it's only possible to upload images and videos. So, here you have my form:


There're some textboxes and a listbox which source is a query. In the criterias of the query I write Like [Forms]![Formulario1]![Textbox] & "*". That creates a filter while you type in the textboxes.
For example, if I type an "H" on the Reference textbox and "6" on the ØD textbox, the listbox will show all the registers that the reference starts by "H" and the ØD is 6. Like in the following screenshot:

But sometimes I need the listbox to show all the registers that ØD is "greater than" 6, and that's what I don't know how to do.

[Batraul]

Quickfinder.zip

I think now I could attach the file...

[June7]

What do you think of the suggestion in post 2?

[Batraul]

What do you think of the suggestion in post 2?

But I have a query from a table with almost 4000 registers? And that's only the begining, it will be more than double.
I'm sorry but I'm new to vba Access. Is it really viable to do for this case?

[June7]

What is a register - a record? Even double 4000 is a very small dataset.

Is what viable - the code from the referenced link? Yes.

[Batraul]

What is a register - a record? Even double 4000 is a very small dataset.

Is what viable - the code from the referenced link? Yes.

Ok June7. I will try to understand properly the code and I will try to create.
Thank you very much for the help.