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

thanks
simon

How are you deleting it?

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

I meant the code, but try

DoCmd.SetWarnings False
your code here
DoCmd.SetWarnings True

thanks worked a treat