DaoEnrol Step 2

Lesson 3 of the Enroll tutorial, Using a Second Recordset, continues both the DaoEnrol and Enroll tutorials by showing you how to add a second recordset and use it to fill a combo box control on the form. Follow the topics in Lesson 3 of the Enroll tutorial listed below to complete Step 2 of DaoEnrol.

First, in the Enroll tutorial Lesson 3, complete these topics:

• Using a Second Recordset
  
  
• About Step 2
  
  
• Changing the Course Control to a Combo Box
  
  
• Binding the Combo Box Control to a Recordset Field and a CComboBox Variable

Next, complete the following DaoEnrol Step 2 topics, which vary slightly from those in the Enroll tutorial:

• Creating a Recordset for the Course Table in DaoEnrol

  The steps for selecting a data source are different for a DAO-based database application.

• Embedding the Recordset Object in the Document Object in DaoEnrol

  The names of files you use differ in DaoEnrol.

• Filling the Combo Box in DaoEnrol

  A substitute code block for DaoEnrol is provided because the DAO database classes handle parameterizing a query differently than the ODBC database classes.

• Filtering and Parameterizing the Recordset in DaoEnrol

  This topic does not add code to the tutorial, but provides details on how the DAO database classes handle parameterized queries.

• Parameterizing the Filter in DaoEnrol

  Discussion

Finally, from the Enroll tutorial, Lesson 3, complete these topics:

• Reusing a Database Object Opened by Another Recordset
  
  
• Sorting the Recordset
  
  
• Requerying the CSectionSet Recordset

Note   The figures in Lesson 3 of the Enroll tutorial show “Enroll” in the title bar of the mainframe window. Your application will show “DaoEnrol”. Remember to substitute CDaoRecordset for CRecordset, CDaoRecordView for CRecordView, and so on.