Sort records in a set of subforms

J

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.
 
J

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 ?
 
D

Duane Hookom

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

Jay

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

In your debt,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top