Combo Box Values

[Matt]

Hi

I am working on a searchable database using a form as my interface. I want to have a combo box that contains the names of the queries that I want, not the values that are inside 1 particular query. I do not see a feature that allows me to do that with the wizard. I thought of typing the names of the queries into the combo box, but then how would I link those names to the names of the actual queries. Let me know if you can help, thank you very much

-Mat

 

[Eric Cárdenas [MSFT]]

Hi,

I am working on a searchable database using a form
as my interface. I want to have a combo box that contains
the names of the queries that I want, not the values that
are inside 1 particular query. I do not see a feature that
allows me to do that with the wizard. I thought of typing
the names of the queries into the combo box, but then how
would I link those names to the names of the actual queries.
Let me know if you can help, thank you very much.

-Mat

--------------------
If you want to populate a combo box with the queries saved in your
database, you would need to write some VBA code. You will use the QueryDefs
collection to list all the queries.

For more information, please consult your Microsoft Visual Basic Help.

Hope this helps,