form data view

[Guest]

when i use the form to enter data and if i scroll through it shows the
previous data entered. What do i do if i want to see the data in the
numerical order. the field are Proposal (Eg) 20051306 then i have initials
and project name. In the forms i want to sort it by the proposal #

I also have the table for this buy i want that to be sorted the similar way
allways. The files were transfered from excel file. How can i do this.
thanks

 

[Joan Wild]

Change the recordsource for your form. It likely is your table. You can
change it to a query, or a SQL statement where you can set the sort order.
If you click on the build button (...) beside the recordsource, it'll open
the query designer. Double-click the * to add all the fields, and then add
the Proposal field; uncheck the show checkbox and choose ascending in the
sort order. Close the window and it will change the recordsource to a SQL
statement with the sort order.

As for the table, you shouldn't care about the order there. It's just a
container for the data - use a query for setting any criteria and sort
orders, and use forms for entering data.