2 fields in onecombobox

[rwahdan@gmail.com]

Hi,

I have 2 fields that holds phone number 1 and phone number 2 for clients. I need the manager to be able to search for a phone number inside combobox weather he inserts a number from first or second field.

phone number 1 phone number 2
555-1234567 555-9876541
555-9898989 555-8785423


all 4 numbers should be searchable in one combobox....is that possible?

database attached...Form1, combobox search engine at the top....



Thanks,
Rami

[Micron]

he inserts a number from first or second field.

Inserts where?

No database attached.

[rwahdan@gmail.com]

Attached file

[Micron]

still not sure what you want - a combo with 2 columns showing numbers side by side? All numbers in one list?
still don't know where anyone is inserting a number into.
I made these changes based on what I think you're asking for:
change combo row source to
SELECT Tenants.TenantPhone, Tenants.TenantPhone2 FROM Tenants;
column count = 2
column widths 1;1 (inches)
control width = 2

[rwahdan@gmail.com]

Hi,

To be clear, I want them in one column....phone 1 and phone 2 listed in one column not 2 separates columns...

TenantPhone
0501228293
00971501228293

TenantPhone2
0557626410
050-7626410

instead of 2 i need them in 1...

0501228293

00971501228293

0557626410

050-7626410

[Micron]

then combo needs only one column with a row source of

SELECT Tenants.TenantPhone FROM Tenants
UNION
SELECT Tenants.TenantPhone2 FROM Tenants;

[rwahdan@gmail.com]

Thanks A lot....It worked