Control Source

  • Thread starter Thread starter AccessDummy
  • Start date Start date
A

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
 
It happens because the textbox isn't bound to the database. There are
various ways to make this work, but really, you shouldn't be storing data
that can be re-calculated that easily. It's a waste of space, and can cause
update problems. If you need to display the value elsewhere, on a report,
say, use a query to calculate the value.

HTH

--
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...
 
Back
Top