Row source problem

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

Guest

Hi,


I'm having problems with this report. It has a combo box that is giving me
the autoId number instead of the name I want. the Row Source is set to

SELECT [agent name].[agentautoID], [agent name].[name] FROM [agent]

and the Bound colunm is 1

No matter what I try its giving me the number not the name. What should I
change this to?
 
set the combo box's ColumnCount to 2, and the ColumnWidths to 0 for the
first column and as wide as you need for the second column - example:

ColumnWidths 0";1.5"

btw, i hope you don't really have a field in your table called "name".
"Name" is a reserved word in Access; you should not use Reserved words as
the names of tables, fields, or any other objects you build in your
database.

hth
 
Paul

In addition to Tina's suggestions, you may have this field defined as a
"lookup" data type in the underlying table. See the tablesdbdesign
newsgroup for extended discussions of the "evils" of lookup data types.

Basically, a lookup field stores one thing (typically, the ID number), while
displaying something else (oh, I don't know, maybe a name?!).

This sounds very much like the symptoms you are seeing.

The solution, if this is the issue, is to stop using lookup data types and
do your looking up in combo boxes (and list boxes) on forms.
 
Thanks that work!

I kinda inherted this DB and there are a few things wrong with it. Can
naming a field "name" or "date" or any reserved name cause real problems?

tina said:
set the combo box's ColumnCount to 2, and the ColumnWidths to 0 for the
first column and as wide as you need for the second column - example:

ColumnWidths 0";1.5"

btw, i hope you don't really have a field in your table called "name".
"Name" is a reserved word in Access; you should not use Reserved words as
the names of tables, fields, or any other objects you build in your
database.

hth


Paul said:
Hi,


I'm having problems with this report. It has a combo box that is giving me
the autoId number instead of the name I want. the Row Source is set to

SELECT [agent name].[agentautoID], [agent name].[name] FROM [agent]

and the Bound colunm is 1

No matter what I try its giving me the number not the name. What should I
change this to?
Click to expand...
Click to expand...
 
Back
Top