"GoToRecord" box?

[WalterInOz]

I have a continues form that holds a few thousand records, each record has a unique primary key autonumber (not visible) and a unique book number that I assign. Numbers currently range from 0001 to 3378.

When I know I need to go to e.g. record 2222 I don't want to scroll through the whole list but would like to have a field in the header of my form in which I can type the booknumber I'd like to pull up. Can that be done?
I know I can be done with a listbox and an unbound txtbox but I'm just wondering if there's an easy way.

If not, too bad, I'll have to go the long way, but it would be nice.

Thanks,
Walter

 

[namliam]

Walter,

Is this not the same question as you asked here http://www.access-programmers.co.uk/forums/showthread.php?t=107893 ???

greets from amsterdam

 

[WalterInOz]

Walter,

Is this not the same question as you asked here http://www.access-programmers.co.uk/forums/showthread.php?t=107893 ???

greets from amsterdam

The same? No, not at all!
Read again, they are completely different issues. Here I seek a solution for when I first open the form and want to go to a certain record. The other issue relates to returning to this form from another form and automatically going to the right "level" in the form.

Groeten uit Brisbane van een ex-Amsterdammer

 

[namliam]

The method is the same tho in the first one you need to "link to" or "retrieve" the value from the OpenArgs. In this one you fetch the number from the textbox...

Method in essance is the same....

 

[WalterInOz]

Good, got this one to work the way I wanted it by retrieving the number from the textbox and clicking the "Go" button frmBooks2 opens up with the correct record. One problem solved.

The other question namliam is refering to is different though I think (that's why I made it a different posting).

 

[Rich]

You could just type the record number straight into the Record number box

 

[WalterInOz]

You could just type the record number straight into the Record number box

My booknumbers are not identical to the record numbers so typing in the record selector doesn't work the way I want it to. Or can you change the way the record selector works too?

 

[WalterInOz]

Works like a charm with a little extra added luxury thanks to our moderator Modest (see this thread, http://www.access-programmers.co.uk/forums/showthread.php?t=108015)