SubForm Sort Order

[Cotty42]

Hi All

I am having an issue with the sort order on a subform.

Basically I have a main form with Client Details and a subform hich displays the associated test results for this client. Each client can have multiple test results which should be displayed in date order.

Initially the form was based on the table 'TestResults' and I set up the form with the Orderby property set to the field 'TestDate' and OrderByOnLoad set to True. This didn't work and the records were displayed in random order.

Next I tried setting up the form based on an SQL query with the field 'TestDate' sorted in Ascending order - same result. Tried this with OrderBy and OrderByOnLoad both set/unset as a pair and individually - always the same result.

:banghead:How can I get the subform to display the test results in date order?

Many thanks for your help.

Cheers

Dave

 

[CazB]

the sort should be specified within the query / select statement of the subform's Record Source.... well, that's how it works on mine, anyway!

Make sure you hove removed any other sorts on the subform

 

[pbaldy]

Make sure the data type of the field it date/time, not text. You'll get an alphabetic sort if it's text.