Software

Ask something
Discussion Locked

Access Find Button

0 helpful
1 reply

by trimac06

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I created a report and used the Access wizard to create a Find button. This Find button however, generates an error msg each time I use the "previous" and "next" buttons on the Report. How do I solve this and get the button to search a particular field within a table?

1 reply

by bristar

What is the error message?
Mine says this in the code:
----
On Error Resume Next
DoCmd.GoToRecord , , acNext
If Err.Number = 2105 Then
MsgBox "You are at the end of the records."
End If
---
The point of the On Error clause to to trap the possible error messages. The point of the If statement is to trap the specific error to say that you are at BOF or EOF. This just makes it more friendly. If you want, when you reach an EOF or BOF you can reverse to the last record by moving back and forth.

This discussion is closed to new replies.