The writes a recordset class for you that selects all records in a single table. You will often want to modify that behavior in one or more of the following ways:
Set a filter or a sort order for the recordset. Do this in
OnInitialUpdateafter the recordset object is constructed but before its Open member function is called. For more information, see Recordset: Filtering Records (ODBC) and Recordset: Sorting Records (ODBC).
Parameterize the recordset. Specify the actual run-time parameter value after the filter. For more information, see Recordset: Parameterizing a Recordset (ODBC)
Pass a customized SQL string to the member function. For a discussion of what you can accomplish with this technique , see SQL: Customizing Your Recordset's SQL Statement (ODBC).