Sorting within a Subform

[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

 

[John Vinson]

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.

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

 

[Jack]

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

 

[John Vinson]

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.

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?