Set focus problem on a form

W

Wylie C

I have a form in Access 2000 with a delete record button and an exit button.
They work fine but because I have setfocus statements on some fields 'On
Exit' procedures, the record will not delete or the form will not close unitl
all the setfocus statements have been executed. Below is the code for the
delete record button.
Private Sub DeleteRecord_Click()
On Error GoTo Err_DeleteRecord_Click


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

Exit_DeleteRecord_Click:
Exit Sub

Err_DeleteRecord_Click:
MsgBox Err.Description
Resume Exit_DeleteRecord_Click

End Sub

The Close form coding is:
DoCmd.Close
DoCmd.OpenForm "Switchboard"

How would I modify it so when it is clicked it would bypass all the other
forms coding and delete the current record?

Thank you.
 

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

Top