control boxes

  • Thread starter Thread starter Ralph
  • Start date Start date
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
 
You are not putting a value in stLinkCriteria
.
 

Users who are viewing this thread

Back
Top Bottom