Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Oct 2002
    Location
    Sheffield, Yorkshire, England
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Recalc Method Problem

    I have code written in Access 2003 that uses the recalc method on a subform and then transfers a calculated control value to the main form. This has stopped working in Access 2007 - the calculated control value is always zero. If I insert a break point and step through the code it works as it did in Access 2003.

    Any suggestions as to what I can do to make the code work in Access 2007 would be most appreciated.

  2. #2
    Star Lounger
    Join Date
    Oct 2002
    Location
    Sheffield, Yorkshire, England
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I've got round the problem with a nasty Timer loop of 1 second, but it would be nice to know what is going on and how to correct it more elegantly.

  3. #3
    Star Lounger
    Join Date
    Jan 2010
    Location
    Oregon
    Posts
    61
    Thanks
    9
    Thanked 0 Times in 0 Posts
    How about using a control on the main form to reflect the value from the subform. Just call this routine every time the subform value is recalculated:

    MyTextBox = Forms("MainFormName").("SubformName").Form("Contro lNameWithCalculatedTotal").Value

    Basically a pull instead of a push. Hope this helps.

Posting Permissions

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