Multiple sources for a listbox or combo-box

  • Thread starter Thread starter Wintech
  • Start date Start date
W

Wintech

Hi There,
I have a database that I am using to store emails I send to customers &
suppliers.
What I want to know is this, is there a way that I can select more than one
source to create
the rowsourse for a combo box.

Eg:
In the Table1 there is a field called Email and in Table2 there is a field
called Email.
When I click the dropdown on the combo-box I want it to display any email
addresses that exist in both tables in one row.

Table1 - Email Table2 - Email
(e-mail address removed) (e-mail address removed)
(e-mail address removed) (e-mail address removed)
(e-mail address removed) (e-mail address removed)

Result:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

Thanks
 
Use a Union query:

SELECT Email FROM Table1 UNION SELECT Email FROM Table2 ORDER BY Email
 
Back
Top