I am a beginner to the more technical aspects of Microsoft Access
(2000) and was wondering if any one can help. I have 3 buttons on a
form which add, delete and search for a record. However, when I click
on the respective buttons absolutely nothing happens! I was wondering
if anyone could help? The code I have is below...
ADDING A RECORD
Private Sub cmdaddstudent_Click()
On Error GoTo Err_cmdaddstudent_Click
DoCmd.GoToRecord , , acNewRec
Exit_cmdaddstudent_Click:
Exit Sub
Err_cmdaddstudent_Click:
MsgBox Err.Description
Resume Exit_cmdaddstudent_Click
End Sub
DELETING A RECORD
rivate Sub cmddeletestudent_Click()
On Error GoTo Err_cmddeletestudent_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Exit_cmddeletestudent_Click:
Exit Sub
Err_cmddeletestudent_Click:
MsgBox Err.Description
Resume Exit_cmddeletestudent_Click
End Sub
SEARCHING FOR A STUDENT
Private Sub cmdsearchstudent_Click()
On Error GoTo Err_cmdsearchstudent_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_cmdsearchstudent_Click:
Exit Sub
Err_cmdsearchstudent_Click:
MsgBox Err.Description
Resume Exit_cmdsearchstudent_Click
End Sub
There it is! Absolutely no sense to me but any help would be VERY MUCH
appreciated.
Thanks in advance
Matt