You would have to concatenate your values. The combobox only shows the
results for one column.

--
Regards,
Tom Ogilvy

"Syed Haider Ali"
<Syed.Haider.Ali.1te7ya_1123416320.9105@excelfor um-nospam.com wrote in
message news:Syed.Haider.Ali.1te7ya_1123416320.9105@excelf orum-nospam.com...

Dear Freinds,

I have a table having 3 fields. 1st Feild for Codes, 2nd for Name of
Account and 3rd for Opening balance. I need codes for if i click a
command botton "Find". and if found then both Code and name of account
would be shown in a same ComboBox. (Suppose " 000123 Capital
Account" ) and the third feild in a seperate textbox. and when we
click command botton "ok". it will filter the database on a second
worksheet according to the comboBox selected item.

Syed Haider Ali


--
Syed Haider Ali
------------------------------------------------------------------------
Syed Haider Ali's Profile:
http://www.excelforum.com/member.php...o&userid=21994
View this thread: http://www.excelforum.com/showthread...hreadid=393649