Open Form DESC Order by Date Not Working 2

[hext2003]

OK, What am I doing wrong?

I have a form with a Tabbed Sub Form. When I click on one of the tabs (history) it should open up the sub form and show all changes made to this project in DESC order of date.

I have set the Sub Form Order By Property to tblHist.dtChg DESC

Open the form, still in Ascending order.

I have even tried this...
Private Sub Form_Open(Cancel As Integer)
Form_Audit.OrderBy = "dtChg DESC "
End Sub

Still NOT correct Order.

I can click in the field then Click the DESC button, but I don't want my users to have to do that.

WHAT am I missing here? is there another parameter I am not looking at?

 

[RoyVidar]

Form_Audit might be referencing another instance of the form - so I'll go for using

[tt] me.orderby = "dtChg DESC"
me.orderbyon = true[/tt]

note also the orderbyon property

Roy-Vidar

 

[hext2003]

Thank you!

That orderbyON Property... I think did the trick!!

Thank you!