Solved UNION query in VBA (1 Viewer)

tihmir

Registered User.
Local time
Today, 13:33
Joined
May 1, 2018
Messages
226
HI all,
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:

theDBguy

I’m here to help
Staff member
Local time
Today, 13:33
Joined
Oct 29, 2018
Messages
19,210
Yes. What happened when you tried it?
 

Users who are viewing this thread

Top Bottom