Sorting on open (form)

[teiben]

I have a form, which is based on a table. Usually I have forms open to new or last records, but in this case I need it to open sorted by reportnumber. I read up on the orderby property, which I tried on open without any luck. Any ideas, other than basing by forms on queries....

 

[ansentry]

Base the form on a query (using your table as its source), you can then select which ever field you want to sort by.