Combo Boxes - DISPLAYING multiple fields after choice is made

P

PHS

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.
 
G

ghetto_banjo

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.
 
J

J_Goddard via AccessMonster.com

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

John
 
K

KARL DEWEY

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

PHS

I'll try it... thanks!

KARL DEWEY said:
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 said:
Remember that the column numbering is "0" based, so columns 2 and 3 are .
column(1) and .column(2)

John




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



.
 
P

PHS

thanks for the reminder/tip...

J_Goddard via AccessMonster.com said:
Remember that the column numbering is "0" based, so columns 2 and 3 are .
column(1) and .column(2)

John




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



.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top