AutoNumber not in order 2

[netrusher]

On my Form I have an AutoNumber for identification purposes. When scrolling through the records on the Form
from Record to Record the AutoNumber is not in order. What do I need to do for the First record to be 1000
which is the First Autonumber. Now when I hit go to first Record 1003 shows up and 1000 is like the 4th record
to show up. I think I had this issue years ago and have forgotten what to do to correct it.

 

[Remou]

You can order the table or query by anything. Autonumber is not always the best thing to use.

 

[netrusher]

Remou

When I go to first record on a form or last record on a form
I want to have the first AutoNumber or Last Autonumber
appear. I don't think I am sorting I just want to browse
through the Forms in AutoNumber order. Right now if I select
go to First Record it goes to Record 1003. When I select
go to Last Record it goes to Autnumber 1000. I want it to
go to Autnumber 1000 when I select go to First Record and
then to keep everything in order by the AutoNumber. Any
suggestions?

 

[Remou]

You can use the OrderBy property of the form. In the Load event of the form put:

Me.OrderBy="[Autonumber Field Name]"
Me.OrderByon=True

 

[netrusher]

Thanks Remou!