Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Form update after delete

Author  Topic 

CPEPhantom
Starting Member

6 Posts

Posted - 2004-09-13 : 10:55:37
Greetings all,

I am having a problem getting my form to update gracefully after I delete one of its underlying records. The form is used for creating purchase requests and relies on 2 tables (orders & products). I have written a routine that deletes the current request but then the form "hangs" and gives me a "record is deleted" error any time I try navigating after that. Any help you guys (and gals) can give will be appreciated.

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-09-13 : 14:35:49
after deleting the row, try calling the Requery() method of the form.

- Jeff
Go to Top of Page
   

- Advertisement -