Forms and simple expressions

[Guest]

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!

 

[Guest]

Did you set its Control Source to the appropriate field in your table?

 

[Guest]

Daniel I thought I did - maybe I did it wrong - how exactly do you do that?

 

[Guest]

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.

 

[Guest]

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?

 

[Rick Brandt]

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?

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.

 

[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