i'm opening a table through the use of a form.

however, the order of the records is not how i wish to view.

how can i change this??

thank you for your help.

Use a query as the recordsource foryour form. Sort the query the way you want to see the data.

HTH,
Jerry

if i can't change the recordsource how else could i do this??

ie. is there a default that i can change that will allow me to order the table by most resent entries??

thanks again!

Create a query that selects all the columns that you need for the form and set it to sort however you want. Save the querydef. Open the form in design view. On the data tab, delete the table name from the recordsource and replace it with the query name. As long as you didn't change any field names, everything should work just fine.