Your question kind of implies that you believe records necessarily have
associated sequence numbers and that you will know what a given record's
number is. They don't and you won't. A table is a bucket of data and the
records are stored in no particular order. New records may be stored in
spaces where old records were deleted, etc. Most queries have an Order By
clause. so that the data is presented in a meaningful sequence.
If you want to navigate your form to a particular record, try this:
Enable Header and Footer in your form's design and, with wizards enabled,
create a combobox in the Header of your form. The wizard will ask what you
want to do. You want to perform a record operation in that you want your
form to go to the selected record.
Once the wizard is done, test your combobox. If it works, you'll probably
want to label id Find WhateverItIs. Place and tweak to suit.
This way you don't have to type anything in, just select the desired record
and the AfterUpdate event will fill your form with data from that record.
HTH
