ordering by date in a form

[migaccess]

I have created a form with many companies. each companies have 4 events in one year,but the first event in the form is the last one. How can order this events in this form chronologically?


Thanks in advance for your help forum

[pbaldy]

You can base the form on a query with the appropriate sort or use the OrderBy property of the form.

[bgwool]

In the Properties tab of the form, type the name of the date field and ASC or DESC depending on the direction you want. E.g. - [DateField] ASC

[migaccess]

In the Properties tab of the form, type the name of the date field and ASC or DESC depending on the direction you want. E.g. - [DateField] ASC

First of all thanks for the prompt reply.
I have looked at the properties tab in the form but I still do not know where to do what you're suggesting.Forgive my ignorance but I am still learning
how to do things in access. Can you give more steps details?
Thanks again

[pbaldy]

Did you notice post 2?

[June7]

Order By is on the Data tab of Properties Sheet.