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 (whose output is a 1-column list of records) to be shown in the
second combo box.

Thanks in advance,

Alejandro.

Watch this:
http://www.datapigtechnologies.com/f...combobox2.html


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Alejandro" wrote:

> 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 (whose output is a 1-column list of records) to be shown in the
> second combo box.
>
> Thanks in advance,
>
> Alejandro.
>