the expression builder

[tnt]

I have set up a table and a form initially when i use these without
modifications the data transfers fine.

However when i use the expression builder to create a calculation in
one of the form controls, the calculation works fine but the data i
get from modified control is no longer transferred to the table when i
save and exit the form.

Help? Any ideas why it doesn't transfer anymore?

[Allen Browne]

The Control Source property of a text box can be either:
- the name of the field where you want the entry stored, or
- an expression such as a calculation.
It cannot be both.

The calculation should not be stored in the table, unless you need the
flexibiltiy to change it to a value different from the calculation result.
This article explains when and how to store the result of a calculation in a
field:
Calculated fields
at:
http://members.iinet.net.au/~allenbrowne/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"tnt" <sa*******@yahoo.com.au> wrote in message
news:63**************************@posting.google.c om...

I have set up a table and a form initially when i use these without
modifications the data transfers fine.

However when i use the expression builder to create a calculation in
one of the form controls, the calculation works fine but the data i
get from modified control is no longer transferred to the table when i
save and exit the form.

Help? Any ideas why it doesn't transfer anymore?