How to sort table automatically

[DanielConserv]

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

[BrianB]

Try .. record a macro whilst using Data/Sort then you can run it whenever you want.

[Besoup]

You could re-create the form using a select query, that is sorted by whatever field you want.