Hi Richard,
Just watched your multi column forms video and I have done something similar for a Student Class Scheduling system.

However I approached creating the columns using multiple sub forms and each sub form was a different group.

The school runs the same class once a month for 11 months each year.  The system can handle multiple courses and multiple classes over multiple years.

3 tables are involved.
1. Student Table
2.Class Table - holds where what and when about the class
3. A Junction table which holds a Autonumber, StudentID and ClassID.

I have created a Form which holds the course details and the Class details.

I have created 11 sub forms and each sub form uses a query based on the appropriate the month the course is being run.  Each of the 11 sub forms going across the screen like columns in a spreadsheet.

The sub form looks exactly like a column in a spreadsheet which just displays the student name.

I dont need a Temp table or loop through a record set to display all selected records.

I also use your Calendar application and in each list box display each course that is running on each day in the month.  You click on the class and it runs the form and sub forms above giving the Scheduler an overview of the students in that class for the year.

Regards

Ron de Boer