Index problem

[Andre Joly]

I have a form in wich I use a table with the primary key
indexed on an autonumber field. On the last four record
creation, I find that if I open the form, the most recent
record created is displayed in lieu of the first record
in the table.

If I scrool down the list, I get the four records
recently created then the first record in the table.

If I open the table and filter the records I find that my
4 recent records are on top not the end of the list.

Any Ideas...

Thanks

AJ

 

[Gary Miller]

Andre,

Tables are not really designed to dish out records in a
specific order, kind of like a bowl of popcorn does not keep
the popcorn in any order. If you want to see your records in
a specific order, create a simple query with all of your
fields in it and set the sort order for the query how you
would like to see the records. Now change the RecordSource
for your form from the Table to the Query.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________