deleting record without confirmation

  • Thread starter Thread starter Grumpy Willis
  • Start date Start date
G

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.
 
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.
 
Back
Top