Combo Boxes - DISPLAYING multiple fields after choice is made

For the life of me, I can NOT get my combo box to DISPLAY multiple (3) fields
(other than the bound/control field) after a choice is made in the combo box
pulldown. A user first picks an item in another text box, which runs a
"refresh contol" macro for the combo box in question (and the combo box has
an imbedded query that "pulls" the data for the 3 fields - then a choice can
be made in the combo box, which it allows for, but does NOT display the other
two fields. I don't necessarily need to store the data for the other two
fields/columns, just display them (and store just the first/bound column).
Help?! Thanks in advance.

I don't think it can display more that one column when not in the
"pulldown view".

you could setup some textboxes that have control sources of:

=cboMyCombo.Column(2)
=cboMyCombo.Column(3)

etc, to grab the data from those unseen columnds.


or setup a listbox to display the rest of the data after a choice is
made in the combobox.

Remember that the column numbering is "0" based, so columns 2 and 3 are .
column(1) and .column(2)

John


ghetto_banjo wrote:
I don't think it can display more that one column when not in the
"pulldown view".

you could setup some textboxes that have control sources of:

=cboMyCombo.Column(2)
=cboMyCombo.Column(3)

etc, to grab the data from those unseen columnds.

or setup a listbox to display the rest of the data after a choice is
made in the combobox.

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via http://www.accessmonster.com

Concatenate the fields like this --
SELECT SomeID, [FName] & " " & [LName] & " - " & [Dept] FROM UrTable ORDER
BY [LName], [FName];

--
Build a little, test a little.


"J_Goddard via AccessMonster.com" wrote:

Remember that the column numbering is "0" based, so columns 2 and 3 are .
column(1) and .column(2)

John


ghetto_banjo wrote:
I don't think it can display more that one column when not in the
"pulldown view".

you could setup some textboxes that have control sources of:

=cboMyCombo.Column(2)
=cboMyCombo.Column(3)

etc, to grab the data from those unseen columnds.

or setup a listbox to display the rest of the data after a choice is
made in the combobox.

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via http://www.accessmonster.com

.

thanks for the ideas

"ghetto_banjo" wrote:

I don't think it can display more that one column when not in the
"pulldown view".

you could setup some textboxes that have control sources of:

=cboMyCombo.Column(2)
=cboMyCombo.Column(3)

etc, to grab the data from those unseen columnds.


or setup a listbox to display the rest of the data after a choice is
made in the combobox.


.

thanks for the reminder/tip...

"J_Goddard via AccessMonster.com" wrote:

Remember that the column numbering is "0" based, so columns 2 and 3 are .
column(1) and .column(2)

John


ghetto_banjo wrote:
I don't think it can display more that one column when not in the
"pulldown view".

you could setup some textboxes that have control sources of:

=cboMyCombo.Column(2)
=cboMyCombo.Column(3)

etc, to grab the data from those unseen columnds.

or setup a listbox to display the rest of the data after a choice is
made in the combobox.

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via http://www.accessmonster.com

.

I'll try it... thanks!

"KARL DEWEY" wrote:

Concatenate the fields like this --
SELECT SomeID, [FName] & " " & [LName] & " - " & [Dept] FROM UrTable ORDER
BY [LName], [FName];

--
Build a little, test a little.


"J_Goddard via AccessMonster.com" wrote:

Remember that the column numbering is "0" based, so columns 2 and 3 are .
column(1) and .column(2)

John


ghetto_banjo wrote:
I don't think it can display more that one column when not in the
"pulldown view".

you could setup some textboxes that have control sources of:

=cboMyCombo.Column(2)
=cboMyCombo.Column(3)

etc, to grab the data from those unseen columnds.

or setup a listbox to display the rest of the data after a choice is
made in the combobox.

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via http://www.accessmonster.com

.