Sorting within a Subform

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

I have a form that sorts the records based on a date.
Within this form, I have a subform that sorts on a second
date (within the subform).

When the form is first opened, the subfom sort works as
indicated in the OrderBy field. However, when I move to
another record (on the mainform) the subform sort does not
work.

Any assistance is greatly appreciated.

Jack
 
When the form is first opened, the subfom sort works as
indicated in the OrderBy field. However, when I move to
another record (on the mainform) the subform sort does not
work.
Click to expand...

Base the Subform on a Query sorting by the field you want.
 
John,

I have tried that and it does not work either. Something
must be awry on my end though because when I open the
subform independent of the main form, it will not pull the
records as they are sorted within the table.

Any other suggestions would be great but I will look at
maybe rebuilding the subform from scratch and try again.

Thanks,
Jack
 
I have tried that and it does not work either. Something
must be awry on my end though because when I open the
subform independent of the main form, it will not pull the
records as they are sorted within the table.
Click to expand...

A Table HAS NO ORDER. If your subform is based directly on the Table,
it makes *absolutely no difference* how the records are sorted in the
Table - the table sort is for viewing only, and Access will return
records to the Subform in whatever sequence the query optimizer finds
handy.

You say you tried using a sorted Query. Could you post the
Recordsource property of the form you're using as a subform? What is
its Order By property, and what order are you seeing the records?
 
Back
Top