Assign query results to combo box

[Alejandro]

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.

 

[Linq Adams via AccessMonster.com]

The concept is called "Cascading Comboboxes." Googling with that term should
get you a gazillion or so hits.

Here's one tutorial on the subject:

http://bytes.com/topic/access/insights/605958-cascading-combo-list-boxes