I think this would probably be the best method on your issue:
[ol][li]Copy your table (structure only) to a new table - give it some other name - you can always rename the new table later.[/li]
[li]Make sure the field formats carried accross in the copy - for instance, your date field is still date, your autonumber field is still autonumber.[/li]
[li]Create an Append Query that takes all the fields (except your autonumber field) and inserts them into your new table.[/li]
[li]With your new query, sort that query by the Date column in the query definition (design view).[/li]
[li]Run the query, telling Access that yes you want to append these records..[/li]
[li]Now your data should be in the correct order in the new table.[/li]
[li]Once you've verified the data in the new table is correct, delete the old table, and rename the new table to the old name (if the table name was important).[/li]
[/ol]
And for future reference, this would have been more of a table issue than a form issue, since it's the table data, not something on the form. For future reference, try to post your question(s) in the most likely forum.
In case you've not done so, it would also be a good idea to take a look at:
faq219-2884
and
faq181-2886
--
"If to err is human, then I must be some kind of human!" -Me