Order by problems (1 Viewer)

[Mansfield]

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.

 

[alxj]

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