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;"