Results 1 to 3 of 3

Thread: Afterupdate

  1. #1
    Join Date
    Jan 2010

    Unanswered: Afterupdate

    I have the following code:

    Private Sub txt69_AfterUpdate()
    Rollup.Value = txt69.Value
    End Sub

    I have the rollup Control Source property set to a field on my table. However it seems that the afterupdate code above does not do anything. The textbox Rollup is empty all of the time. I have similar code for other textboxes and it works fine. Just this one stays blank and does not pull over the value in txt69. Am I doing something wrong?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    are you certain the event is firing
    have you put a break/.watch on that code to make certain its called
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Are you physically entering data in txt69? The AfterUpdate event won't fire if data is entered into it thru code, such as a simple assignment or thru a calculation.

    Otherwise, I'd think about corruption of one of the two textboxes.

    Of course, the really important question here is why do you want to have the same data in two textboxes? This really violates the basic rules relational databases.
    Hope this helps!

    The problem with making anything 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