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
"Steve Schapel" wrote:
> 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
>
> > 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
SteveM - 29 Oct 2007 20:35 GMT
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.
[quoted text clipped - 46 lines]
>
> Why should I rate a
Rick - 30 Oct 2007 16:45 GMT
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.
[quoted text clipped - 51 lines]
> >
> > Why should I rate a