Originally Posted by
rpeare
If you don't do that I would suggest a search function rather than going to record x, particularly if you can delete data from your table. if you have record 1 through 10 today and record 1 through 12 tomorrow but record 3 and 4 have been deleted going to record 5 will result in different results each day. Also the person using the database would have to know which record number was relevant. It would probably be a better idea to supply an unbound control (or a couple of controls) to help the user search for specific items then display the subset of records rather than always looking at the entire dataset.