sir is there any vba code to display the specified record in the access form according to the id number that i entered (eg. 1 represents first record 2 for second etc..)
Hi. That depends. There is no inherent sort order for the data in a table. However, if you use a query, you can specify how the records should be ordered, so you can tell which record is the first and which one is the second.