Forms Calculations

[Donald Sweat]

If I want to calculate field3=field2*field1 before the record is saved on a
form, what is the best way to do this?

Thanks,
Donnie

 

[fredg]

If I want to calculate field3=field2*field1 before the record is saved on a
form, what is the best way to do this?

Thanks,
Donnie

As control source of an UNBOUND text control:
=[Field2]*[Field1]

The result of the calculation will appear on the form... but is NOT
saved, nor should it be saved, in a table.

Any time you need the result of [Field2]*[Field1], simply recalculate
it, as above.

 

[Guest]

thank you. I needed this.. I was putting my expression in the incorrect
spot. This really helped.
--
Sandie Hetland
Ephesians 2:1

If I want to calculate field3=field2*field1 before the record is saved on a
form, what is the best way to do this?

Thanks,
Donnie

As control source of an UNBOUND text control:
=[Field2]*[Field1]

The result of the calculation will appear on the form... but is NOT
saved, nor should it be saved, in a table.

Any time you need the result of [Field2]*[Field1], simply recalculate
it, as above.