What does the 'Order by' Property of a form do?

[Peter2222]

Hello,

I've sorted out a problem that I had with a Form that had a subtable on it, by setting on the properties of the form for the 'Order by' criteria to equal the Id number of the form. eg: if each record has an Idnumber I have put [Idnumber] as the Order by property.

I have no idea what this does though, even though it seems intuitive? it's a form... so what is there to order? hope i'm not just being very stupid!

Thanks

Peter.

 

[GUIDO22]

This is the sort order automatically loaded with the report in accordance with the Recourdsource property - (NB. help tips are visibile in the status message bar at the bottom of the screen when you place the mouse cursor in a field on the properties dialog box)

 

[Peter2222]

Re

Hi,
Thanks for the tip, so does it set the order in which the subtable is ordered in?
Thanks
Peter

 

[GUIDO22]

No - just the resulting record set from the query.