Sort records in a set of subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 ?
 
Never mind Duane. I got the correct SQL syntax working and your approach
works like a charm. Thanks a bunch.

In your debt,
 
Back
Top