Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2007

Tip: Looking for answers? Try searching our database.

Calculations in Form do not display in the table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve Garrill - 03 Mar 2007 17:55 GMT
Help!
I've created a simple table.
From that I created a form to enter the data.
One of the fields (subtotal) adds two other fields together eg
[input1]+[input2]
The result displays correctly in the form but when I go back to the table
the input1 and input2 values are displayed but nothing where the subtotal
should be.
It worked the other day so I've changed something and I've now spent almost
3 hours trying to work it out!
Rick Brandt - 03 Mar 2007 18:00 GMT
> Help!
> I've created a simple table.
[quoted text clipped - 6 lines]
> It worked the other day so I've changed something and I've now spent
> almost 3 hours trying to work it out!

I doubt that it worked the other day.  Controls bound to expressions never save
their values to the table. The ONLY way that a control's value is saved to the
table is when the ControlSource is the name of a field, not an expression.  The
result of expressions do not need to be saved to tables nor should they be.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.