Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Recalculate a formula (2000)

    Hi,

    I've got a from that has a control labled [AmountAllocated]. There is also a control called [TotalAllocated] which contains the formula =Sum([amountallocated]). The forumla in this control is correct and works fine whenever the sheet loads. I need it to update each time there is a change made to [amountallocated]. I've tried using requery in the afterupdate function for [amountallocted] but that doesn't work. Any suggestions would be appreciated.

    Thanks,
    Leesha

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Recalculate a formula (2000)

    The instruction to force recalculation is Recalc. It is a method of the form.

    Private Sub AmountAllocated_AfterUpdate()
    Me.Recalc
    End Sub

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Recalculate a formula (2000)

    Thanks Hans! That worked great!!!

    Leesha

Posting Permissions

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