Hi,

I have been struggling to do this. I have a table called student. Then, a form that is from the student table. In a table, i have an ID(that is autonumber), studentID, blah blah...

The trouble that i have is when i open up the form to flip through a record by record, it's not exactly in order for example it goes 1,100,101,102,103,2,20,21,22... something like that. So, this is very hard for me to edit record by record.

I've been deleting the old form that did that and creating a new one that does exactly the way i want it to but as soon as i added a new record, the problem rise up again. By the way, I add the new record to the last.

What should i do?

Thank you very much