Changing Record Order

[wessleym]

How can I set the order of a group of records after they
have been entered? My problem is that I have several
entries with dates. I can do Sort Ascending in the date
field within the table view, but that doesn't change
their order in the forms I have made for it. So how can
I make the database sort the records by date so that they
will appear in the right order when viewed in forms?
Thanks.

 

[DDM]

wessley, create a query based on your table, sorting the dates as part of
the query definition. Then base your forms on the query, rather than on the
table.