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

Thanks in advance,

Alejandro.

 

[Marshall Barton]

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.

RunSQL is only useful for Action queries, so I don't see how
that idea can work. I think all you need to do is assign
the query name or SQL statement to the second combo box's
RowSource peoperty.

 

[John W. Vinson]

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.

There is no need to *run* the query using RunSQL or the .Execute method.
Simply set the combo box's RowSource property to the SQL string.

In fact, it's probably not necessary to do even that; you can base the second
combo box on a Query referencing the first combo box as a criterion:

=Forms!YourFormName!FirstComboName

and Requery the second combo in the AfterUpdate event of the first.