Getting records to display in order

[ibbledibble]

I have a form that displays the actions we take on our casework. Obviously, each set of actions is self-contained in that only those carried out on that specific case are shown within that case.

However, they don't always display in order of their reference number and I'm not sure why. Therefore, the most recent action we carried out could be displayed first, or even in the middle of the list and I have no idea why.

How do I get them to display in order?

 

[CyberLynx]

Try setting the Form's Order property. Put in he Table Field Name you want to sort by, like this:

[MyTableFieldName]

By default it will sort in Ascending order. If you want to sort in Descending order then you would enter:

[MyTableFieldName] DESC

.

 

[gemma-the-husky]

or look at the source of the form (which should be a query, rather than a table), and get the query presorted in the way you require

 

[ibbledibble]

It's a table