I have set up a searching function on a form. It works well finding records initially. The problem I am having is if I am on record 355 and I try and find record 325 I get the message that the record is not found. I know the record exists. So how do I change my search function to go backwards?
This is my code:
Private Sub btnFindPAQ3280_Click()
On Error GoTo Err_btnFindPAQ3280_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_btnFindPAQ3280_Click:
Exit Sub
Err_btnFindPAQ3280_Click:
MsgBox Err.Description
Resume Exit_btnFindPAQ3280_Click
End Sub
This is my code:
Private Sub btnFindPAQ3280_Click()
On Error GoTo Err_btnFindPAQ3280_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_btnFindPAQ3280_Click:
Exit Sub
Err_btnFindPAQ3280_Click:
MsgBox Err.Description
Resume Exit_btnFindPAQ3280_Click
End Sub