Sort automatically on opening a form

[OrionElectrotech]

Can anyone tell me how to set a form up so that it will sort automatically on opening?

It is a simple form, based on a table with just a date field and a text field, and I would like it to sort on the date field. I have set the Order By property on the form, but that obviously doesn't apply automatically on opening (2003 version).

I imagine it is a simple bit of code in the On Open property, but I am a novice still when it comes to VBA!

Thanks

Caroline

 

[MajP]

It is a simple form, based on a table

Base the form on a query sorted by date.

 

[OrionElectrotech]

Such a simple solution!

Thanks