IIf then? to Calculate on Checkbox on a Form

K

Kay

On my form - when a checkbox is checked I need to multiply two fields from
different tables and save the product to a third field in a table for future
reporting use. How can I do this?
thanks!
 
K

Kay

Mike,
thank you so much! These tables are not related but I think it's time they
became more acquinted as I have four fields which may need calculations.

I don't understand not wanting to store data in a table from a calculation.
In this case the product stored will later be calculated in a report so I
need the value.

thanks again, Kay
 
Top