Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    After Update event (Access 2000)

    In my continous form if i put an AfterUpdate event , i cannot go down to update the other rows. When i remove the AfterUpdate event, then i can do it. What is the reason for that ?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: After Update event (Access 2000)

    Can you post the code you are trying to put in the after update event.
    Regards
    John



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

    Re: After Update event (Access 2000)

    Can you tell us what your After Update code is? Do you modify the record in this code? You shouldn't do that, use the Before Update event if you want to modify the record.

  4. #4
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: After Update event (Access 2000)

    Thank you very much. !I am sending the attachement

  5. #5
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: After Update event (Access 2000)

    yes, unfortunately thats exactly what i am trying to do, to modify the record. But i am sure you will find the solution

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

    Re: After Update event (Access 2000)

    Your attachment didn't make it...
    - Make sure that you have zipped the database and that the zip file is less than 100 KB in size.
    - Don't preview your post after specifying the attachment.

  7. #7
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: After Update event (Access 2000)

    Thank you for the replies.Do apologize me for the omission.I took note of your advice and i have done the calculation in the query.So i solved the problem but thank you for the attention and the helpful advie

Posting Permissions

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