Ordering records in a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed Warren - 01 Jun 2006 01:03 GMT

Form A contains Form B as a subform
in Form B's onopen event I have set the sort order as:

Private Sub Form_Open(Cancel As Integer)
Me.OrderBy = "[datetimecreated] DESC"
End Sub

When the Form A opens and I select a record the detail records in Form B
fail to be ordered as required.

So how, and where should I put the code to force the proper sorting of the
records.

Thanks,

Ed Warren.

Reply to this Message

Tom Lake - 01 Jun 2006 02:29 GMT

> So how, and where should I put the code to force the proper sorting of the
> records.

Create a query sorted the way you want and use it for Form B's source.

Tom Lake

Reply to this Message

Ed Warren - 01 Jun 2006 03:08 GMT

Thanks, sometimes the really stupid tricks are overlooked!!! I was making
this much too hard.

Ed Warren.

>> So how, and where should I put the code to force the proper sorting of
>> the records.
>
> Create a query sorted the way you want and use it for Form B's source.
>
> Tom Lake

Reply to this Message

Ron2006 - 02 Jun 2006 19:37 GMT

Whenever you want to programmatically set the sort order or the filter
you also have to set that action on.

Example:

Private Sub Form_Open(Cancel As Integer)
Me.OrderBy = "[datetimecreated] DESC"
Me.OrderByOn = true
End Sub

Reply to this Message