How to suppress the delete confirm box and go on?

G

G Lam

Hi, I use the following codes to delete a record, but every time, Access
2000 pops up a delete confirmation box and asks for confirmation. How can I
suppress this box and keep on going without the user clicking a button?
Thank you
Gary

(Afterupdate event VBA codes)
If Bcode = OldOBC Then
Pieces = Pieces + 1
DoCmd.GoToRecord , , acNext
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Endif
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Answer "Yes" when delete a record 1
Can't delete a record with this slightly modified code: Access 03 4
Can I Suppress Write Conflict Message? 4
add one to a duplicated record that checks to see if one exists 0
Deleting a picture 3
double conformation on delete 2
delete record 3
Dialog box prevents record deleting 5

Top