Multiple sources for a listbox or combo-box

[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

 

[Douglas J. Steele]

Use a Union query:

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

 

[Wintech via AccessMonster.com]

Works Great,
Thanks

Use a Union query:

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

Hi There,
I have a database that I am using to store emails I send to customers &

[quoted text clipped - 25 lines]

Thanks