Sorting of forms

Z

Zanstemic

I'm new to access so, any suggestion even if it may seem simple is a help.

When entering into the database, the user goes directly into a form that
displays fields in the database. Currently the sorting is based on the order
they were entered.

I've tried to change the sorting of the form by changing the sorting in the
associated table, without success.

Any suggestions are appreciated.
 
K

kingston via AccessMonster.com

Open the form in design mode and modify the OrderBy property in the Data tab.
When you're done, save the form. The user can easily overwrite this though
so you might set this parameter in the command that opens the form.
 
J

John Spencer

even better might be to base the form on a query (where you can specify the
ORDER BY) instead of directly on a table.
 
Top