Populate combo box based on selection from another combo box

[ryonker]

Good afternoon,

I've been trying to find a way to filter one combo box based on another combo box selection. My problem lies herein. The first combo box is a list of import dates. I need the second combo box to populate with the Vendor names that were imported on the date that has been selected from the first combo box. Based on the selection of the second combo box I then need my form to populate the records that are associated with the two selections. I would like to do this using VBA. Any help is greatly appreciated.



Robert

[ajetrumpet]

please post the table structures from your db that are relevant to this Robert.

[jlclark4]

Maybe this is what you are looking for. Here is a sample. Hopefully it helps!

[ryonker]

Sorry for the long delay but the sample database helped and I got it working. thanks everyone for responding and the help.

[marcohag]

question about the filter, i have a problem with this (because my combo boxes ar repeating through the recordset

record1 combobox1 - combobox2 - combobox3
record1 combobox1 - combobox2 - combobox3