formulae in form fields

[annonymous]

I have a form which is made from a table, and I want one
of the fields to be the multiplication of two other
fields but to stay linked to the same field in the table.
This is so that the calculated value will be input into
the table.

 

[Jeff Boyce]

First, you probably DON'T want to store a calculated value. While there are
some instances where this is useful, it is much more often both sufficient
AND considerably less work to use a form to merely display the calculated
value.

If you add an unbound text control to your form, and set its control source
to the multiplication of the two other fields, will this work?

 

[Peter De Baets]

You could create a query based on your table, then add the calculated
field to the query. Then use the query as the form record source.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com