Sorting of forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
even better might be to base the form on a query (where you can specify the
ORDER BY) instead of directly on a table.
 
Back
Top