A
ashlanddave
How would you insert the result from a query and assign it to a value in a
form (and table). The two inputs from the form are pricing and product which
are established in the form. The query then assigns a unitprice based on the
2 form inputs and stores it as a value in table: order.unitprice.
I previously tried using an IIF statement in the form text block with
=IIF.... as the control source. That lookup up the values, showed the
unitprice on the from, but did not save anything into the table.
Any Suggestions??
form (and table). The two inputs from the form are pricing and product which
are established in the form. The query then assigns a unitprice based on the
2 form inputs and stores it as a value in table: order.unitprice.
I previously tried using an IIF statement in the form text block with
=IIF.... as the control source. That lookup up the values, showed the
unitprice on the from, but did not save anything into the table.
Any Suggestions??