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]

Re: the expression builder

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" <sakeji_oz@yaho o.com.au> wrote in message
news:6311248c.0 408051816.2b9ca 37a@posting.goo gle.com...[color=blue]
> 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?[/color]