Combobox.column()

[John]

Hi,
How would I set a field to show 2 combobox columns.
i.e. [firstname] and [second name]

At the moment I amusing an event in the afterupdate box of the combobox to
populate the text box with a first name.
I know I can put 2 text boxes and bind it to column(3) but I just wondered
if it was possible to put 2 columns in1 text box as you can on a report.
i.e. [FirstName]&""&[SecondName]

Regards

John

 

[Rick Brandt]

Hi,
How would I set a field to show 2 combobox columns.
i.e. [firstname] and [second name]

At the moment I amusing an event in the afterupdate box of the
combobox to populate the text box with a first name.
I know I can put 2 text boxes and bind it to column(3) but I just
wondered if it was possible to put 2 columns in1 text box as you can
on a report. i.e. [FirstName]&""&[SecondName]

The answer is contained in your own post.

=ComboBoxName.Column(0) & " " & ComboBoxName.Column(1)

 

[John]

Rick,
Thanks for the reply.
I think the word i'm looking for is "Doh"

Regards

John

Hi,
How would I set a field to show 2 combobox columns.
i.e. [firstname] and [second name]

At the moment I amusing an event in the afterupdate box of the
combobox to populate the text box with a first name.
I know I can put 2 text boxes and bind it to column(3) but I just
wondered if it was possible to put 2 columns in1 text box as you can
on a report. i.e. [FirstName]&""&[SecondName]

The answer is contained in your own post.

=ComboBoxName.Column(0) & " " & ComboBoxName.Column(1)