Sorting in a subform

[smehnert]

Hi All... please read on and see if you can help

GOAL: To sort my subform data in descending order;

I have a subform off a large query... the query has other forms off it...

so on the subform I have used the Order By property...

qryDeliveries.EntDate DESC

sure enough when the subform is opened the continuous data is sorted in descending order by date....

BUT.. When I add this subform to my unbound main form it doesn't sort the subforms data? I didn't want to sort on the query because it runs other forms???

Please advise

Simon

 

[MStef]

Hello Simon!

Try this, in Sub Form_Load put this code:
Me.OrderByOn = True
I think it'l be OK.

 

[smehnert]

Fantastic, works a treat!