Navigate to "Number" In Access DAP?

[lemkepf]

Hello. I'm working in a microsoft DAP (office 2000).
My users want to be able to go to a certain number in the DAP. Basically, it says 1 of 300 at the bottom. Is there a way a user can type in 40 and it goes to record 40 and then says 40 out of 300 at the bottom.

Just to show you how desperate i am... I did a for loop:
for i = 0 to txtFilterNo.value
MSODSC.CurrentSection.DataPage.MoveNext
next

yea, not too good. Because once you are at record 40, and you do it again, it'll advance 40 more records and say 80. Yea, i need help!!! Thanks alot guys!!!
Paul

 

[lemkepf]

Hey, just an update on my problem. Maybe someone else would know how to get around this problem...

I updated the page, so that i have a running count for the amount of skus in the DAP. so when the user "onrowenter" the count is updated 1. So i have a tally of where i am in the recordset. Then i can just do that for loop and move to where i want to be.

My next problem is what happens if the user hits the "move previous" button? How can i catch that, and decrement the tally by 1?

Any thoughts? or a better way of doing this? (let's just say, this is very inefficient!)
Thanks again guys!
Paul