Forms and simple expressions

M

Michael

I am set up a simple expression in a form (Field A+Field B+Field C, etc) and
the value that access is calculating is not appearing in the table that I
have the form linked too. Any assistance to help explain and correct this
would be much appreciated!
 
D

Daniel

Open the Properties Dialog for the control in question and then goto the Data
Tab. Make sure the Control Source is pointing to the Field that you want the
data to be saved in. If it isn't then click the arrow on the right-hand side
on the Control Source and select the field from the list that appears.
 
M

Michael

Daniel this is helping a lot! However that is where I built the expression
to do the adding. Should that expression be built somewhere else?
 
R

Rick Brandt

Michael said:
Daniel this is helping a lot! However that is where I built the
expression to do the adding. Should that expression be built
somewhere else?
Click to expand...

A control either coantins an expression OR is bound to your table. It cannot do
both.

The good news is you should not be trying to save the result of a calculation in
your table anyway. You have an expression that gives you the result you want.
Just use that wherever you need it and delete that field from your table.
 
B

BMore via AccessMonster.com

Rick, not always the result of a calculation should not be stored (= based-
copied-down). When one of the items can change in time and you need to keep
historical accuracy, there is no other way than to store it.

So, just set the control source to the table and use a macro or VBA to set
the calculated value to it.

Ben
 
Top