Subform Sort Order

[Guest]

I have a form with 2 linked subforms. One form is for data entry and the
other is datasheet view.

They are linked in the main form with
Private Sub Form_Load()
Set Me.sfmHolidays.Form.Recordset = Me.sfmHolidays2.Form.Recordset
End Sub

The form is for maintaining a Holidays table so it is desirable that the
records are displayed by HolidayDate DESC - I have tried using Order By in
the subforms, but the records are still displayed ascending.

Any suggestions please

 

[Alex Dybenko]

hi,
Try to sort like:

Private Sub Form_Load()
Set Me.sfmHolidays.Form.Recordset = Me.sfmHolidays2.Form.Recordset
Me.sfmHolidays.Form.OrderBy="HolidayDate DESC"
Me.sfmHolidays.Form.OrderByOn=True
End Sub

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Thanks Alex

That worked for the data entry subform so I just added the same 2 lines for
the datasheet subform and everything is great.

This forum is invaluable.

Thanks