jad0083
asked on
How to add item to a combobox Rowsource (table/query) that is not part of the query statement.
Good Afternoon,
I have a simple ComboBox that queries the items from a table. Is it possible to programatically add items to that combobox that is not on any field in the table. The logic behind this is that I'm using the queried items from the table as a means to filter another query. I'm hoping to add "all" as part of the rowsource on the combobox.
Attached is the simple query:
I have a simple ComboBox that queries the items from a table. Is it possible to programatically add items to that combobox that is not on any field in the table. The logic behind this is that I'm using the queried items from the table as a means to filter another query. I'm hoping to add "all" as part of the rowsource on the combobox.
Attached is the simple query:
substr = "SELECT DISTINCT Sub from Questions WHERE Questions.LOB = '" & strind & "' ORDER BY 1 ASC;"
Try:
Select Distinct Sub from questions etc.
UNION All
Select top 1 'All' From questions;
Select Distinct Sub from questions etc.
UNION All
Select top 1 'All' From questions;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the quick solution, exactly what I needed, thanks!
Thanks, glad to help.
see this link for example
http://support.microsoft.com/?kbid=210290