Results 1 to 3 of 3
  1. #1
    mommyof4kids is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    20

    Update calculated field on form


    Have a form that users can enter estimated hours, these hours stored in table. Each payperiod may have a different payrate. I have an unbound field on the form to calculate Hours * Rate (which equals the estimated cost...I am not storing this calculation) and it works, however, if the user changes the hours, the estimated cost does not update unless you hit the refresh button. How do I make this automatically refresh. I have tried the Me.Refresh command..maybe I am putting it in the wrong place? Thanks (Access 2016)
    Last edited by mommyof4kids; 08-23-2017 at 06:40 AM. Reason: I have figured it out

  2. #2
    mommyof4kids is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    20
    Figured it out...have entered Me.Refresh under the ON CURRENT

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    FYI, the specific command to redo calculated fields is Me.Recalc.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Use a calculated field to update multiple fields
    By AnneForumer in forum Queries
    Replies: 1
    Last Post: 10-27-2016, 07:05 AM
  2. Replies: 3
    Last Post: 02-13-2013, 10:15 AM
  3. Update (Refresh) Calculated Field
    By libraccess in forum Forms
    Replies: 2
    Last Post: 06-08-2012, 05:27 PM
  4. Update Query with a Calculated field
    By Lorlai in forum Queries
    Replies: 3
    Last Post: 09-21-2011, 10:57 AM
  5. Update table from calculated field in a form
    By BernardKane in forum Forms
    Replies: 3
    Last Post: 11-28-2006, 09:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums