Order by entering sequence

[Bello]

Hi all,

For a form with record source set to a table, how do we order the records by their entering sequence? In other words, I want the latest added record to be displayed when I click the 'last record' navigation button.

I'm not sure but seems Access will automatically sort the records according to an indexed field in the table.

Any advises would be highly appreciated.

Thanks,
Bello

 

[Jack Cowley]

If your Primary key is an autonumber then base the form an a query sorted on the Primary key field.

hth,
Jack

 

[Bello]

Hi Jack,

Thanks for your help. I've got the problem solved.

 

[Jack Cowley]

You are welcome. Glad you have the problem 'sorted'....

Jack