Delete a record

[yhgtbfk]

To delete a record, I use:

DoCmd.RunCommand acCmdDeleteRecord

I want to run some code before it. Ie:

Delete the student out of the library table (cant be bothered typing the code)

Then:

DoCmd.RunCommand acCmdDeleteRecord 'Deletes the student out of the student table

The problem is that it asks you whether or not you want to continue. So if the user clicks no, then the student is deleted out of the library table, but remains in the student table.

What is the delete command to delete the current record but not ask for confirmation?

 

[WayneRyan]

y,

Use the Search Facility here and look for "DoCmd.SetWarnings"

Wayne

 

[yhgtbfk]

Thank you. It worked a charm.