Microsoft® Office Access 2003 Inside Out

Understanding Max Records

You learned earlier that you can set Default max records (in the Options dialog box) for the entire project and the Max Records property for individual forms. You already know that Default max records for the Contacts project is set to a very high number—60,000 records. To see the interaction of these two settings in action, open the frmXmplContacts10 sample form and drop down the Postal Code combo box list, as shown in Figure 19-7.

Figure 19-7. A form that has a Max Records setting of 10.

Notice that the form’s navigation bar indicates only 10 records in the recordset, but the Postal Code combo box shows a matching value ...