Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Screen update in continuous form (Access 2K (SR-1))

    I use a continuous form to display data in datasheet-like format. However, when a row is deleted from from the form, screen update doesn't occur as was in Access 2K datasheet view. The row is still there but with "#deleted" indicating deletion of the row. I want the row to disapppear and its position taken up by rows below it. Is there a simple way of doing it? Please help.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Screen update in continuous form (Access 2K (SR-1))

    Try the following command in the AfterDelConfirm or AfterUpdate event of the form:

    Me.Requery

    HTH
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screen update in continuous form (Access 2K (SR-1))

    No, Patt, it doesn't work. I used either or both AfterDelConfirm and AfterUpdate of the form, but there is no screen update and the "#deleted" on the deleted row stubbornly stayed. Is there any other way to force a screen update after deletion? BTW, I used DAO for my database objects.

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Screen update in continuous form (Access 2K (SR-1))

    I finally make it. I don't know exactly what I did, but after modifying my query and issuing a Me.Requery immedately after closing my recordset, the screen was updateed. When I stepped through my codes, it appeared that the AfterDelConfirm or AfterUpdate event wasn't executed after deletion of a record. Thanks.

Posting Permissions

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