deleting record without confirmation

[Grumpy Willis]

Can anyone help me?

I need to have a button on a form that deletes the record, but which doesn't
pop up the "You are about to delete 1 record(s)" confirmation dialogue box.

Can this be done?

Thanks
Rich.

 

[Steve Schapel]

Rich,

If you are using a macro, precede the macro action (RunQuery or RunSQL
or RunCommand/DeleteRecord presumably) with a SetWarnings,No action.

If you are using a vba procedure, similarly put
DoCmd.SetWarnings False
ahead of the delete code, and in this case you will also need to put
DoCmd.SetWarnings True
afterwards.