Ordering Data within a form

[system243trd]

Hi,



I have a table that contains the following fields

ID
Date
Note

The form that I have created is based on the table. I want the form to be ordered by date and not the ID. Is it possible to create some VBA that opens the form and automatically sorts the fields by date?

Thanks

[pbaldy]

No code needed, unless you want it to be dynamic. Either base the form on a query with the appropriate sort, or use the Order By property of the form. You can set the OrderBy and OrderByOn properties in VBA, but like I said I wouldn't bother if you always want it sorted the same way.