Use query for row source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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, 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,

These properties define a combobox which will show one column.

The Row Source property is a query which only includes one field
(FullName) from the [EPR/TR/OPR] table in any case. So adjusting the
other properties will not affect that fact.

If you want more columns to be displayed in the combobox's drop-down
list, then you will have to first of all change the Row Source to
include the other columns you want.

Here's an example of what the Properties might look like if you wanted
the combobox's dropdown list to include the HairColour field as well as
the FullName

Row Source = SELECT [EPR/TR/OPR].[FullName], [EPR/TR/OPR].[HairColour]
FROM [EPR/TR/OPR];
Column Count = 2
Column Widths = 1.7605",1.1"
List Width = 2"
Bound Column = 1
 
Back
Top