HI all,
I need to create UNION query in VBA like this:
Do I have to declare a variable like Dim sSQL As String
sSQL = SELECT .......
Then I need to match with combobox like this:
Me.combobox.RowSource = sSQL
I need to create UNION query in VBA like this:
Code:
SELECT [Inspector]
FROM qryInspectors
UNION SELECT Top 1 "- Department DZK -"
FROM qryInspectors;
Do I have to declare a variable like Dim sSQL As String
sSQL = SELECT .......
Then I need to match with combobox like this:
Me.combobox.RowSource = sSQL
Last edited: