Hi All, I have a form where I can push buttons to move forward or backward in the recordset. Searching for a key field works OK as well. After the search, however, the movenext and moveprevious methods "remember" the position in the recordset before the Search. Is there a way to reset the recordset so that moveprevious and movenext actually move +1 or -1 records from the "found" record? Thanks, Dan.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MovePrevious, MoveNext not in sync after key search
- Thread starter Dan01
- Start date
- Thread starter
- #3
Hi jimbOne, sorry 'bout the confusing question. I tried to requery the recordset using the where clause in SQL and thus crashed and burned. I realized all I had to do was loop through the existing recordset and compare the input key value with rs!myKey. Everything works fine now. My apologies to all who read this email. Dan.
- Status
Similar threads
