I have a Delete Command Button create on a split form which does not working.

voet to
voet to used Ask the Experts™
on
Hi.  
I have a delete Command Button create on a split form which does not working. I take so many time. So, I browsed through the discussion board and found a suggestion.

Thanks you
vietto
Database6.accdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
I think you've got a problem with the form. When I try to click the button, I get an error about a problem with Microsoft Access communicating with an OLE Server. This often means corruption. I tried a Compact/Repair but that did not work.

I'd suggest recreating the form. Also, instead of that involved macro, you can use VBA code to delete a record quite easily. Just issue this VBA command in the Click event of the button:

DoCmd.RunCommand acCmdDeleteRecord

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial