Prev: Using a subform to display and add info into table
Next: Page Order in Tab Control
From: PHS on 17 Mar 2010 10:50
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.
From: ghetto_banjo on 17 Mar 2010 11:27
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.


From: J_Goddard via AccessMonster.com on 17 Mar 2010 12:03
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

From: KARL DEWEY on 17 Mar 2010 12:51
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
>
> .
>
From: PHS on 17 Mar 2010 16:11
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.
>
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Using a subform to display and add info into table
Next: Page Order in Tab Control