Forms & Calcs & Populating a table

[Gerald Stanley]

There is no need to store fieldC on the database. Storing
calculated columns creates an overhead in storage and
maintenance. As you have shown, it is simplicity to
include the calculation in any form and report.

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
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.

 

[Guest]

Gerald

Thanks for the answer, and under most circumstances I would agree with you that populating that field is not necessary

However, in this one instance I really do need that number mapped to a table every time. It sounds nuts, but it is necessary

One way or another, I will have to find a work-around. I have an idea, as I mentioned, for writing the values to a bunch of variables for each of the assigned-to-a-sub-procedure controls

What I do need to do is assign those vlues to class-level variables. Do you know by chance if placing the class-level variables in the (General) (declarations) area will be sufficient

Thanks
pep
----- Gerald Stanley wrote: ----

There is no need to store fieldC on the database. Storin
calculated columns creates an overhead in storage an
maintenance. As you have shown, it is simplicity t
include the calculation in any form and report

Hope This Help
Gerald Stanley MCS

-----Original Message----
Does anyone know whether or not this is possible withou writing code for it.
Field
Field
Field
Basically it is a multiplication problem. I need to ente

two numbers, one into FieldA then one into FieldB. Th
fields map into a table where the field names ar
identical. This works without a hitchvisually display the product of FieldA and FieldB (so
FieldA * FieldB) through the Control Source in Propertie
being set to do a calculationdisplay the product visually in view form, but also at th
same time to populate it into FieldC