Sorting of forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zanstemic - 16 Nov 2006 14:13 GMT

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.

Reply to this Message

kingston - 16 Nov 2006 15:34 GMT

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.

>I'm new to access so, any suggestion even if it may seem simple is a help.
>
[quoted text clipped - 6 lines]
>
>Any suggestions are appreciated.

Reply to this Message

John Spencer - 16 Nov 2006 16:23 GMT

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

> Open the form in design mode and modify the OrderBy property in the Data
> tab.
[quoted text clipped - 14 lines]
>>
>>Any suggestions are appreciated.

Reply to this Message