1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access 2007, Recalculate field after data is pulled from table. OBP??

Discussion in 'Business Applications' started by ginaw, Apr 14, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. ginaw

    ginaw Thread Starter

    Joined:
    Sep 8, 2010
    Messages:
    81
    Now that I have the rate information pulling from my other table, the Rate Total won't calculate unless I overtype the rate field with a new entry. What I would like to do is just press enter to confirm the field and move past it and have the total automatically recalculate.

    I think that this would be an event procedure on Enter but I don't know what VBA code to use to make it happen?

    Can you please tell me if this is correct and what code will make this recalculate?
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    How is the Rate Total calculated at the moment?
    You would use the On Exit or After Update event.
     
  3. ginaw

    ginaw Thread Starter

    Joined:
    Sep 8, 2010
    Messages:
    81
    The Rate Total is Calculated with VBA coding. Do you still have dbase I sent you? I can resend if I need to.
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Then you need to copy the Total part of the code to the After Update of the Rates field.
     
  5. ginaw

    ginaw Thread Starter

    Joined:
    Sep 8, 2010
    Messages:
    81
    OBP,
    The Total part of the code is already on the After Update of the Rates field. I guess I'm not following you.
     
  6. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    I forgot you aren't changing anything, you need it in the "On Exit" or "Lost Focus" as well.
     
  7. ginaw

    ginaw Thread Starter

    Joined:
    Sep 8, 2010
    Messages:
    81
    OBP,

    Brilliant as usual. Pasted the code into ON Exit and worked like a charm.

    I have one last problem, but I will list that on a different thread as I think this is all valuable information that people may need.

    You are the man!!
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/991452

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice