I have a subform linked to a form. I have set the Order By property of the sub form to dteDate but when I load them up together the form refuses to order by dteDate. I have also tried setting the Order By property of the form with no success.

I have an autonumber field in the sub form. Could this be causing hassles? Please help.

Try checking out the indexes in the underlying table for your subform.

Open the table
Select design view
From the top menu bar select View, Indexes

Here will be a list of all Sort details for your data. If you have millions of indexes you may have a problem.

Alex