jump to a specified record

[Gkirkup]

I have a form which displays an inventory record. The user can click a button to display the next or previous record. But there may be hundreds of records in the set, so this is slow. I would like to allow the user to jump to a specific record number, which they enter. How do I jump to a specific record number in the set?

Robert

 

[pr2-eugin]

You can use the

DoCmd.GoToRecord , , acGoTo, The_RecordNumber

The record number can be from a unbound Text Box or an unbound ComboBox. Whichever suits your need. Best would be combo, as you be assured that the user does not type Goto 1234 when there is only 5 records.

 

[Gkirkup]

That worked perfectly. Thanks so much!
Robert