Assigning a Value from a from --- with query?

[Guest]

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??

 

[Guest]

It would be helpful if you provided a few examples of your pricing and
products inputs, along with the expected unitprice values.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________