R
Ralph
Guest
I am using the following code for control boxes to allow users to easily move from one form to the next or previous form. One of my problems is that the control does not bring the user to the next form in the same record. What am I missing that would make this flow better.
Private Sub cmdGoToPage3_Click()
On Error GoTo Err_cmdGoToPage3_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "COP Page 3"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_cmdGoToPage3_Click:
Exit Sub
Err_cmdGoToPage3_Click:
MsgBox Err.Description
Resume Exit_cmdGoToPage3_Click
End Sub
Ralph
Private Sub cmdGoToPage3_Click()
On Error GoTo Err_cmdGoToPage3_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "COP Page 3"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_cmdGoToPage3_Click:
Exit Sub
Err_cmdGoToPage3_Click:
MsgBox Err.Description
Resume Exit_cmdGoToPage3_Click
End Sub
Ralph