calculated control not saving to field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a calculated control on a form that I thought was a bound control.
It's name is the same as the name of the field I want it saved to.

however, nothing is being saved to the field and I'm not sure why.

Thanks in advance.

Jerry
 
JWCrosby said:
I have a calculated control on a form that I thought was a bound
control. It's name is the same as the name of the field I want it
saved to.

however, nothing is being saved to the field and I'm not sure why.
Click to expand...

Because having the *names* the same means nothing. What causes a control to
get data from a field in the table and save its data to that field in the
table is having the name of the field in its ControlSource property. Your
control has an expression as its ControlSource and thus is not actually
bound to a field at all.

So...controls can either be bound OR contain an expression. They cannot do
both at the same time. The good news is that calculations are not supposed
to be saved to the table anyway. Just remove that field from your table as
you don't need it. Any place you need that value you can calculate it just
as you are on the form.
 
Back
Top