Forms & Calcs & Populating a table

From: Pepenacho (anonymous_at_discussions.microsoft.com)
Date: 05/05/04 

Date: Wed, 5 May 2004 13:31:03 -0700

Does anyone know whether or not this is possible without writing code for it.

In a form I have three fields.
FieldA
FieldB
FieldC
Basically it is a multiplication problem. I need to enter two numbers, one into FieldA then one into FieldB. The fields map into a table where the field names are identical. This works without a hitch.

Now back on the form, FieldC is set up, for the moment, to visually display the product of FieldA and FieldB (so, FieldA * FieldB) through the Control Source in Properties being set to do a calculation.

How can I set up the properties of FieldC, not only to display the product visually in view form, but also at the same time to populate it into FieldC.

I know this is possible by writing some code to it, but I am wondering if properties has an options of setting that up.

Thanks!

Relevant Pages