Combo Boxes - DISPLAYING multiple fields after choice is made

  • Thread starter Thread starter PHS
  • Start date Start date
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.
 
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.
 
Concatenate the fields like this --
SELECT SomeID, [FName] & " " & [LName] & " - " & [Dept] FROM UrTable ORDER
BY [LName], [FName];
 
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



.
Click to expand...
Click to expand...
 
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



.
Click to expand...
 
Back
Top