Sort Order in Tab page

  • Thread starter Thread starter Stan
  • Start date Start date
S

Stan

I have a main form with tab pages. On the first tab page,
I have a form with a subform enbedded. The enbedded
subform has to fields, A date/time field and the other is
a memo field. The source is directly from the table with
the same to fields and ID primary field.

I have the table properties set to sort by the date/time
field in latest to oldest order.

I have the order set in form properties to the date/time
field in latest to oldest order.

In both the table and subform the sort order is working.
The sort order works when the subform is in the initial
form. When I load the form with the subform on to the tab
page the sort order goes back to oldest to newest.

Is there a way to control this?
 
Stan said:
I have a main form with tab pages. On the first tab page,
I have a form with a subform enbedded. The enbedded
subform has to fields, A date/time field and the other is
a memo field. The source is directly from the table with
the same to fields and ID primary field.

I have the table properties set to sort by the date/time
field in latest to oldest order.

I have the order set in form properties to the date/time
field in latest to oldest order.

In both the table and subform the sort order is working.
The sort order works when the subform is in the initial
form. When I load the form with the subform on to the tab
page the sort order goes back to oldest to newest.

Is there a way to control this?
Click to expand...

Interesting, and I'd be inclined to call it a bug, albeit a minor one.
However, if you really want the records to be consistently presented in
a specific order, you'd do best to base the subform on a query (an
in-line SELECT statement will do) that sorts the records the way you
want. I wouldn't rely on the form or the table's Order By property.
 
Back
Top