Hi
Let me put this question in a simple way,
I have a form name : FORM_A
Combo Name : Opera
Note: Combo linked to a table full of Operators i.e <, >, <=, etc.
and there is a Text box called units, user can enter units
1) How in a query, I can write a statment for the following?
in the Qty field,
take the oprator sign from the FORM_A and the qty whater the user entered on the form?
Combine two paremeters from the FORM_A to the query block?
I tried like this, but not working, getting an error msg, complex formmula.
Forms![FORM_A]![Opera] & Forms![TAN Main]![units]
Please help, this driving me crazy..
Thanks