Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Location
    New Zealand
    Posts
    10

    Unanswered: Recalculating controls in a Subform

    I do not even know how to explain this one, so I have attchd a (much pared down ) version
    The idea is to calculate delivery costs and apportion.
    Problem is the values can't be calculated until all the records for that subform are in
    So this works if the user is prepared to enter deliveries in the subform and then go back to the start (the first record) and tab right through to the end of the last record (not really acceptable)
    I have my calc controls recalc in the subform as I go but because I write the values to the table as I go through the subform once I move to the next subform record the value does not update
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by libraccess View Post

    ...I have my calc controls recalc in the subform as I go...
    As I asked on the other forum, 'How?' To recalculate derived Fields on a Form you would use simply use the Command

    Me.Recalc

    and a search of your code does not find this anywhere. It can be placed anywhere within the code of the Form, or Form the Subform is based on, and will re-calculate all values on that Form.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •