MS Access: Filter records based on a combo box selection in Access 2003/XP/2000/97

We've provided a download to demonstrate how you can select a Customer_ID from the combo box and then display the related fields for that particular record.

Filtering records based on the combo box is achieved by using a form and a subform.

Pay close attention to how the RecordSource is set on the form called frmCustomers_sub. The RecordSource on this form is set in VBA code and not in the Properties window.

This RecordSource is then refreshed when frmCustomers is opened and when the combo box is updated.