Pass Full Statement from Form

[bhansen]

I have a unbound form with text boxes in which I pass my criteria to a query, this works great for just sending a value (eg. 02), but I would like the user to be able to type the full search string such as
>02
between "02" and "05"
etc.

Is there a way to do this?

 

[THoey]

I don't think there is any nice way to do this. In a lot of forms you see that will allow this (like a search engine), you will see a drop down listbox that has the qualifyer (>,<,=,BETWEEN) and then a (or multiple)
textbox(es) that has the comparison data. (I mention multiple in the case of a BETWEEN where you would have the start and the stop values. The second textbox could be hidden until BETWEEN is chosen.)

Based on what is selected in the dropdown listbox, you would have an IF statement that would build your WHERE clause.

Does this help? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[bhansen]

This helps, but might be beyond my current Access knowledge.

Thanks Anyways