delete record warning off

[hullstorage]

can somebody tell me how to when i delete a record
it does not warn me first

thanks
simon

 

[pbaldy]

How are you deleting it?

 

[hullstorage]

i have created a button next to the record on click delete
works fine but i am getting the standard microsoft access prompt
are you sure you want to delete

 

[pbaldy]

I meant the code, but try

DoCmd.SetWarnings False
your code here
DoCmd.SetWarnings True

 

[hullstorage]

thanks worked a treat