Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing multiple searching parameters

Status
Not open for further replies.

access345

Programmer
Nov 23, 2005
78
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top