Auto number problem 1

[aids2]

I have a form that uses Auto Numbering.
When I open the form it always goes to a new record. If I sort the field I can get to the first record, when the form is closed and re-opened the sort order is no longer valid and I need to replicate the previous sort.
How do I get the form to retain the sort order so that it always opens on the first record?
The form is bound to a table and contains 2 subforms, I have tried using a query to duplicate the same function and sort the autonumber field but it always ends up showing a new record.
Any help would be appreciated.

 

[hymn]

I have a form that uses Auto Numbering.
Was that done through the table or code. You have set something for the form to show a new record. check your code and your properties for that form

Hope this helps
Hymn

 

[Garridon]

If you use a query behind the form, you can put the sort order in the query on the appropriate field.

 

[Junior1544]

check in the form's properties for a sorting... also for allow sorting... or a sort by...

I havn't used access in a couple of weeks, but i think that may be what your looking for...

--James

junior1544@jmjpc.net
Life is change. To deny change is to deny life.