Alison Balter's Mastering Access 2002 Enterprise Development

Populating Combo Boxes and List Boxes Dynamically

Another important technique in building a client/server application is to make sure that combo boxes populate only with the necessary data. The form called frmReportTechniques contains two combo boxes. The first displays all of the contact titles. The second displays only those contacts with the selected contact title. The frmReportTechniques form appears in Figure 11.38.

Figure 11.38. The form called frmReportTechniques allows the user to select a contact title and then populates the customer combo box with the customers that have that title.

The code that ensures that Access populates the cboSelectContact ...