Assigning a Value from a from --- with query? ashlanddave 24.07.2006 03:05:01 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??

RE: Assigning a Value from a from --- with query? Tom Wickerath 24.07.2006 07:30:01 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 __________________________________________ "ashlanddave" wrote: [Quoted Text] > 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??