Results 1 to 3 of 3

Thread: Afterupdate

  1. #1
    Join Date
    Jan 2010
    Posts
    4

    Unanswered: Afterupdate

    I have the following code:

    Code:
    Private Sub txt69_AfterUpdate()
    Rollup.SetFocus
    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
    Location
    out on a limb
    Posts
    13,692
    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
    Location
    Richmond, Virginia USA
    Posts
    2,763
    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 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
  •