Hello there,
I have two combo boxes in a form and I would like the second box to be populated based on a query run with code. So the user will select an option in the first combo box and based on the selection a DoCmd.RunSQL command will be run in the After Update event of that first box. I would like the result of that query (which is a 1-column table) to be shown in the second combo box.
Thanks in advance,
Alejandro.
I have two combo boxes in a form and I would like the second box to be populated based on a query run with code. So the user will select an option in the first combo box and based on the selection a DoCmd.RunSQL command will be run in the After Update event of that first box. I would like the result of that query (which is a 1-column table) to be shown in the second combo box.
Thanks in advance,
Alejandro.