Combo Box Columns - Selecting

[Guest]

I am new user of Access 2003.
I created a combo box with row source from a query.
The 3 three fields from the query appear in the combo box; however,
when I select a row, only the first column is displayed.

How can I get the remaining fields to show?

Thanks.

 

[fredg]

I am new user of Access 2003.
I created a combo box with row source from a query.
The 3 three fields from the query appear in the combo box; however,
when I select a row, only the first column is displayed.

How can I get the remaining fields to show?

Thanks.

You can't.
A Combo Box (after selection) will only display the first column whose
column width is greater than 0.

What you can do is add an unbound text control to the form.
Set it's control source to:
=[ComboName].Column(1)
to display the second column.
Combo boxes are zero based, so column(1) is the 2nd column.
Do the same for each additional column.

Fred

 

[John W. Vinson]

I am new user of Access 2003.
I created a combo box with row source from a query.
The 3 three fields from the query appear in the combo box; however,
when I select a row, only the first column is displayed.

How can I get the remaining fields to show?

Thanks.

That's how a combo box works. It just shows one field.

You can put textboxes on the form with control sources

=comboboxname.Column(n)

where n is the zero based index of the field you want to show.

John W. Vinson [MVP]