Hello,
I am hoping you can help me. I am using Microsoft access 2007. I have created a command button which when I click it, I would like to go to another form. I have created a On-Click Event with the following code:
Private Sub menu3_Click()
On Error GoTo Err_menu3_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Item Code"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_menu3_Click:
Exit Sub
Err_menu3_Click:
MsgBox Err.Description
Resume Exit_menu3_Click
End Sub
I have added MsgText commands After the Dim statements and nothing occurs. Any ideas as to what I am doing wrong?
Thank you in advance!
Nancy