Find Next Button

Mobiusrune

Registered User.
Local time
Today, 02:09
Joined
Jan 7, 2013
Messages
28
I am having issues with assigning search criteria for the "Find Next Button". I used the wizard and it does not ask what criteria to use for Find Next. I am assuming there is a bit of VBA I need to add to the generic Find Next button. This is what comes up when I use the wizard to create the button:

Private Sub Command118_Click()
On Error GoTo Err_Command118_Click


Screen.PreviousControl.SetFocus
DoCmd.FindNext

Exit_Command118_Click:
Exit Sub

Err_Command118_Click:
MsgBox Err.Description
Resume Exit_Command118_Click

End Sub

How do I define the criteria for the next record. I want the db to move to the next record with the same [PtMRN].
 
Thanks for the link to the article. My hope was to be able to have a find next button while having the drop down combo box for the original search. The find/replace that pops up with the Find Record button seems to be confusing for some users. All the users were comfortable with the combo box.

So again, I am trying to figure out what code I need to add to the Find Next command in order for it to look at the next record with the same PtMRN.
 

Users who are viewing this thread

Back
Top Bottom