TheunsGoosen
Technical User
(Access beginner)
I'm using the following code to call a form from a switchboard, can someone help me with the code to call access page with the same name.
Private Sub Label78_Click()
On Error GoTo Err_Command116_Click
Dim stDocName As String
stDocName = "R001ComponentPriceT001"
DoCmd.OpenReport stDocName, acPreview
Exit_Command116_Click:
Exit Sub
Err_Command116_Click:
MsgBox Err.Description
Resume Exit_Command116_Click
End Sub
Thanks
I'm using the following code to call a form from a switchboard, can someone help me with the code to call access page with the same name.
Private Sub Label78_Click()
On Error GoTo Err_Command116_Click
Dim stDocName As String
stDocName = "R001ComponentPriceT001"
DoCmd.OpenReport stDocName, acPreview
Exit_Command116_Click:
Exit Sub
Err_Command116_Click:
MsgBox Err.Description
Resume Exit_Command116_Click
End Sub
Thanks