I have a single record form with command buttons for gotofirst, previous, next, and last, as well as a list box from which the user canpick a specific record to go to.
I'd like to add a button that allows them to return tothe previous record that they were at... To do this, I need to trap what that record was before I move on to thenext one; which is where I'm having problems. I can't figure out where it could be caught .
I have a public variable to store the primary fieldvalue, which is the reference I would use in a search to return to that record,and have tried assigning it in various places.
The most recent is on the buttondown event of the goto... command buttons thinking I could save the value of the current recordbefore moving to the next... This seemedpromising, but for some reason, code at this event is disabling the button'spreviously working click event, or at least it seems so....!?! So my presumption is that this is not the right place to be....
Putting the code at the form current event was another thought, except that as soon as I move to the next record, the variable is overwritten with "where we are now" at (vs. "where we were...")
Any suggestions will be greatly appreciated in advannce,
Mark