Delete records without use of docmd.domenu...

[Rani VSPL via AccessMonster.com]

Hi group
Is there a way to use delete command to delete the records other than
standard Docmd.domenuitem,acformbar, acmenubar..etc..
In my application I need to delete the records and update the inventory
with the no of items deleted only if the deletion is confirmed.
Can any one help me out.

Thanks

 

[Van T. Dinh]

I am not sure what you are trying to describe in the second sentence but
there are a few alternatives:

* If you want to delete the CurrentRecord on the Form, you can use:

DoCmd.RunCommand acCmdDeleteRecord

* You can, of course, use code (RunSQL / OpenQuery / Execute) to run a
Delete SQL / Query.