Use Query for Row Source - Re-Post

Tech-Archive recommends: Fix windows errors by optimizing your registry

Re-Post question not resolved/provided attention to from 26 Oct 07

------------------------------------------------------------------------------

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

--
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 post?



Expand AllCollapse All

Manage Your Profile |Contact us
© 2007 Microsoft Corporation. All rights reserved. Terms of Use |Trademarks
|Privacy Statement

.

Quantcast