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
[email protected] [email protected]
[email protected] [email protected]
[email protected] [email protected]

Result:
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

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