Use Query for Combo Box Source - Posted 26 Oct 07

[Rick]

Reposting because I feel it may not receive any attention since it was
originally posted last week.
--------------------------------------------------------------------------------------------
Steve, here is the info you requested:

Row Source = SELECT [EPR/TR/OPR].[FullName] FROM [EPR/TR/OPR];
Column Count = 1
Column Widths = 1.7605"
List Width = 1.7604"
Bound Column = 1

Thanks, Rick

Rick,

In design view of the form, can you select the combobox, and look at the
Properties. Can you post back with what is entered in there for these
properties:

Row Source
Column Count
Column Widths
List Width
Bound Column

Was this post helpful to you?

Why should I rate a

 

[Rick]

Thanks Steve,

I'm really only interested in seeing one row but I was having issues seeing
that row so as a test, I pulled two rows to see if any data came through. As
it turns out, the data from the primary key does come through but I still
don't see the data from the one field I need, user name.

Thoughts?

You will only see one field in a combo box no matter how many are in the
RowSource. If you want to see multiple fields you need a Listbox.

Steve

Reposting because I feel it may not receive any attention since it was
originally posted last week.
--------------------------------------------------------------------------------------------
Steve, here is the info you requested:

Row Source = SELECT [EPR/TR/OPR].[FullName] FROM [EPR/TR/OPR];
Column Count = 1
Column Widths = 1.7605"
List Width = 1.7604"
Bound Column = 1

Thanks, Rick

Rick,

In design view of the form, can you select the combobox, and look at the
Properties. Can you post back with what is entered in there for these
properties:

Row Source
Column Count
Column Widths
List Width
Bound Column

--
Steve Schapel, Microsoft Access MVP

Rick wrote:
Similar to JHC message and I tried fredg recommendations with no luck.

Running Office 2003 Professional Edition 2003
Converted database from 2000 to 2003 (problem existed in 2000 as well)
Created Combo Box w/control wizard

I can create the Combo Box usin the wizard, select required fields (only
need one but tested to see if it happens w/all fields which it doesn't. I
can see data for column one, primary key) and while still in the wizard, the
combo box is displaying all information I'm looking for.

Once I finalize wizard, switch to form view, the only data displayed in the
combo bix is bound to colunm one, the primary key. All other fields are
blank. I tried changing the Bound Column, Column Widths, and Column Count as
recommended by fredg but I don't see data for the fields I need. I can see
the columns but they are all blank except for column 1. Any thoughts as to
how I can get the combo box to display all of the data?

Thanks in advance!

Was this post helpful to you?

Why should I rate a