Two Feilds in a combo box

[Syed Haider Ali]

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

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"Syed Haider Ali"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>