Delet record

  • Thread starter Thread starter James J
  • Start date Start date
J

James J

I found this code below to dele a record from my table,
the problem is that it flashes up a message box which
askes if Im sure i want to delete the record
can it be changed so that the message box does not
appear. and it just does the delete action.

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

Thanks
 
I found this code below to dele a record from my table,
the problem is that it flashes up a message box which
askes if Im sure i want to delete the record
can it be changed so that the message box does not
appear. and it just does the delete action.
Click to expand...

DoCmd.SetWarnings False
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Click to expand...
DoCmd.SetWarnings True
 
Back
Top