Sort records in a set of subforms

[Jay]

Hi -

Main parent form with 3 subforms. Each subform is on a page of a 3-page tab
control. Need data on each subform automatically sorted by Date field when
user opens the parent form.

The OrderBy property of the subform on Page1 seems to sort the first subform
properly by date, but the OrderBy properties of the other two forms is
ignored (they're not sorted).

Looking for suggested methods to display all subforms with data in a default
sort order.

 

[Duane Hookom]

I only use the sorting in the form's/subform's record source query.

 

[Jay]

Hi Duane -

Thanks for the response. I haven't tried your suggestion, but is sounds
good since it uses a native approach.

Not sure how to implement, though. Subform1's recordsource property is the
"Job_TimeCard" table and that's all it lists in the record source. Can you
suggest syntax that I would use in that property field ?

 

[Duane Hookom]

Set the Record Source property to:
SELECT *
FROM Job_TimeCard
ORDER BY [...];

 

[Jay]

Never mind Duane. I got the correct SQL syntax working and your approach
works like a charm. Thanks a bunch.

In your debt,