Using a Second Recordset

Enroll: Database Application, Lesson 3

Tip   If you prefer working from a printed tutorial, see in MSDN Library Help for details about printing a lesson, a set of topics, or a single topic.

Note   If you are working through the DaoEnrol tutorial lessons, you will work through the topic Binding the Combo Box Control to a Recordset Field and a CComboBox Variable in this lesson.

Although AppWizard starts you off with one initial pair of recordset and record view classes, you can later use ClassWizard to add more recordset and record view classes. Multiple record views can view the same recordset. Conversely, a record view class can view more than one recordset, although only one of the recordsets can be its primary recordset.

In this lesson, you’ll add some code so that you can view more than one recordset with the same record view.

This lesson explains:

• Replacing the Course edit box with a Course List combo box.

• Creating a second recordset class with ClassWizard.

• Filling the Course List combo box from the second recordset.

• Parameterizing the Section recordset.

• Requerying the Section recordset.

• Building and running Enroll Step 2.

At the end of this lesson, you’ll be able to build and run the Enroll Step 2 application.