Question: I'm using Access 2003/XP/2000/97 and I need to figure out how to display the record details based on a combo box selection. For example, when I select a CustomerID in a combo box, how do I get the related customer name and address information to appear?
Answer: 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.
(scroll to see more)