Why Expression in form fld. not populating the same fld in table?

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

Guest

I added a field to a form & table. I used an expression to populate the form
field. I followed the instructions in the manual & set the controls
accordingly. The same field in the TABLE is NOT picking up the value from the
form. I must be missiing something but can't figure out what it is. Can
someone help? I'm using ACCESS 2002. Running Windows XP/Home/SP2.
 
The Control Source property of the control where you want to view/edit the
new field in the table must be set to the name of the field.
 
Access stores the value into the table field only if the Control Source is
the name of the field. If you use an expression in the control source of a
text box, the value is not stored.

You probaby should not be storing the value in your table. See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html
The brief article explains when and how to store calculated values.
 
Thanks for your help. Let me explain what I have:
In the table I have 3 fields, 'AMOUNT', '6% Sales Tax' and 'Amt + Tax'. I
have the same fields in the form. In the Form ControlSource for the Tax & Amt
field I have the following expression:
=Amount+[6% Sales Tax]. Does this seem correct? Thanks again...
 
Back
Top