Control Source

[AccessDummy]

I have a form with a number of text boxes. One particular text box,TOta
, is calculated from the figures of the data in other text boxes, i.
TOTAL = QUANTITY*COST.

So I have an expression in the control source for the TOTAL text box
The expression get calculated and gets shown on the form but does no
get put into database

anyone know why this happen

 

[Howard Brody]

Is it bound to a field in your table?

 

[Rebecca Riordan]

Please don't multi-post. I answered this in m.p.access.


--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Bruce M. Thompson]

I have a form with a number of text boxes. One particular text box,TOtal

, is calculated from the figures of the data in other text boxes, i.e
TOTAL = QUANTITY*COST.

So I have an expression in the control source for the TOTAL text box.
The expression get calculated and gets shown on the form but does not
get put into database

A calculated control's "Control Source" is an expression rather than a field
name - that makes it an *unbound* control and, therefore, has no field to save
its value to.

If the value is easily calculated (as in your case) then you really shouldn't
save the results to the table. Just calculate it wherever you need to
display/use the results.