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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
FindPrevious Button
- Thread starter delpino
- Start date
tomschafer
Technical User
You may have to fill in some of the parameters but this is the command you'd use...
DoCmd.GoToRecord , , , acPrevious
DoCmd.GoToRecord , , , acPrevious
delpino,
I'm guessing you don't want GoTo...acPrevious, but a FindPrevious? Not a standard 'wizard' functionality. FindNext is always there, but you'll have to code your own FindPrevious. I'm thinking along the lines of saving the 'find next' results--putting the primarykey into a form-scoped array and then going backwards through the array.
Not perfect, but it should fill in if what you're wanting is for a user to hit a 'FindNext' arrow you've created, and then be able to reverse if he passed one up that he wants to review.
--Jim
I'm guessing you don't want GoTo...acPrevious, but a FindPrevious? Not a standard 'wizard' functionality. FindNext is always there, but you'll have to code your own FindPrevious. I'm thinking along the lines of saving the 'find next' results--putting the primarykey into a form-scoped array and then going backwards through the array.
Not perfect, but it should fill in if what you're wanting is for a user to hit a 'FindNext' arrow you've created, and then be able to reverse if he passed one up that he wants to review.
--Jim
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question