Delete Records 1

[luceze]

Is there a way to delete the active record in one form by clicking a button in another form (pop-up).

 

[psemianonymous]

There is the "correct" way, and the "messy/workable" way:

1. Correct: set focus to the other form and run "RunCommand acCmdDeleteRecord", then set the focus back to the popup. This may not work if the popup is opened in dialog mode.

2. Messy:

-Run SQL "DELETE * FROM tbl WHERE ID = " & forms![thefirstform]![ctlThatHastheIDInfo]
-Requery thefirstform

Looking back, they're both messy. So be it.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[luceze]

I had to do it the messier way but it works just fine. Thanks!