Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Form is calculating but table does not show result? (https://www.askmehelpdesk.com/showthread.php?t=800070)

  • Aug 25, 2014, 08:19 AM
    QzQzn
    Form is calculating but table does not show result?
    I have some calculated field in my form and everything seems to be perfect as the calculated field show the correct calculation. However, when I opened my table, the calculated field does not show any value. Any suggestions?
  • Aug 25, 2014, 09:30 AM
    ScottGem
    That is the way it should be. As a general rule we do not store calculated values as they can be displayed anytime you need them using the expression you used. You don't have fields on a form. You have CONTROLS that may or may not be bound to a field in your table. This is a subtle but important distinction that bears on your issue.

    What you did was enter an expression as the ControlSource of the control. That means that the control is not bound to a field in the table so the table is not updated. But, as I said, that's the way it should be. You can use that same expression in a query or on a report to display the value you want. That way the value is always up to date if the data changes.
  • Aug 25, 2014, 04:09 PM
    QzQzn
    Thank You!
  • Aug 25, 2014, 05:19 PM
    ScottGem
    Glad to assist

  • All times are GMT -7. The time now is 02:38 AM.