delete record

[Lior Montia]

Hi,

I have a button in a form that delete that current record.
before it deleted, access ask me if I'm sure I want to delete.
Can I cancel this message and just delete (I want to put my own question
before)

thanks.

 

[storrboy]

Hi,

I have a button in a form that delete that current record.
before it deleted, access ask me if I'm sure I want to delete.
Can I cancel this message and just delete (I want to put my own question
before)

thanks.

These occur when the Tools>Options>Confirm Record Changes settings are
used. You can either turn them off there or use the Docmd.SetWarning.
Docmd.SetWarning False 'Turns msgs off
Docmd.SetWarning True 'Turns them back on

 

[storrboy]

Sorry - that should be DoCmd.SetWarnings - with an 's' at the end.

 

[John W. Vinson]

Hi,

I have a button in a form that delete that current record.
before it deleted, access ask me if I'm sure I want to delete.
Can I cancel this message and just delete (I want to put my own question
before)

thanks.

Use VBA code in the form's BeforeDeleteConfirm event. See the online
help for this event.


John W. Vinson [MVP]