Customize ComboBox in Microsoft Access

Question

I am trying to create a form in Microsoft Access that has 2 ComboBoxes. The first ComboBox is populated with a SQL query that accesses a list of values from a table. The 2nd ComboBox is will also be populated with a SQL query, but the 2nd ComboBox SQL query takes a parameter. I want to use the text that is currently in the 1st ComboBox as the parameter into the SQL query which is the back-end of the 2nd ComboBox. Is that possible?

Answer 1

Yes, you can do this: Basing one combo box on another