Subform data sorting

[John Milward]

Hi

I have a subform which is a datasheet view of test points.
I have set an "Order By" criteria in the forms properties of ...
ServInstPointLimits.Test
This definately works because without it they are not sorted.
If you open the subform the points are in the correct order.

However when you use the main form they are not sorted.

Am I missing something obvious?

Please help. TIA

John

 

[Guest]

Hi John,

Is it okkay to have your subform' record source property based on a Query?
If it is okkay then create a query, ie named it qrydata.
Then on that qrydata you could choose any field that will be used as a
sorted key.
Then on the form choose this qrydata as a record source

Hopefully, that is what you want.