Calculating values in a form based on data already entered

[SwanseaAccess]

Evening all,

How can I enter a default value in a form to calculate a sum based on two other values entered into a form.

For example, in my table I have fields for price, quantity and total value.

If the user enters price and quantity in the form I want the value to calculate automatically.

This seems quite basic but I can't quite seem to crack it!

Thanks.

 

[DCrake]

When using an unbound form on a form you can use

Me.Total = Me.A + Me.B

You do not store total in table as this is a calculation and can be reproduced in a query.

 

[pbaldy]

I'd simply have a textbox:

=Price * Quantity

But there's more here:

http://allenbrowne.com/casu-14.html