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