One record one tab in a sub form?

[CrostonScottish]

Not sure if i am asking too much. I am quite new to the whole subform and tab controls.

I have a form which displays the students details, Name, Address etc. In this form i have a subform which diplays the course the student is enroled on. This is based on an SQL Query linking tblCourselist with tblLINKStudent_Course.

The subform displays the records of the courses enroled on. Great!

BUT

This is not easy to sift through when one student could enrol in a number of courses over their career.

1. Is their a way to force the records displayed in the subform to start with the most recently enroled on and go back in time? I have looked at the filter and order by controls in the form but couldn't get anywhere.

OR

2. Can Tabs be used in the subform which would display each record of a course enroled on for that student in a single tab and could the tab title then be the date enroled on?

Any ideas on how to do either of these two would be great as it would make the database much easier to navigate.

Cheers

CrostonScottish

[nico5038]

The first option is easiest.
Open the subform in design mode and directly look into the form's Properties under the Data tab.
The Recordsource will hold a table or query. Open this using the [...] button behind the field (only visible when it's selected). In the query add a Descending sort on the Date field.

Nic;o)

[CrostonScottish]

Cheers for that. I new it had to be something fairly straight forward, but sometimes i can't see the wood from the trees.

Thanks again.

[nico5038]

Glad I could help, and be sure I feel like a forester sometimes too <LOL>

Nic;o)