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

Topic

New Reply

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.

Reply | Quote

Replies

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

Me.Requery

HTH
Pat

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote