Hi All
I have a access 2007 form with two objects,
1) One combo Box with two operators I.e Less than < and > greater than Sign.
2) second Text Object with Qty I.e 50
All I am doing here is, the user can select greater than or less than sign and enter his/own qty for search
In the qty query field,
I have done like this,
>[Forms]![TAN Main]![units]
this is workign only if I hard coded the operator >, I want to select both the operator sign and the qty to gather. How do I connect both form objects in a query?
Please help
Thank you