Text Showing in Combo Box

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Have you ever known how to do something and in fact have
done it, but now can't remember how to do it again to
save your life? Well, eons ago when I set up my
database, I set up a table with inventors' names, the
primary key being an autonumber, however, in the form, it
somehow programmed it to show the inventor's name instead
of the autonumber. I can't remember how I set it up to
do that. Any suggestions? Somehow, the combo drop down
box shows numbers, where before, I would start typing in
the name and it would show the name. What is interesting
is that in the datasheet view, some have names and some
have numbers? Somehow, somewhere, I had ties the
autonumber and the name together.

Help.

Thanks.
 
Usually, what would be done to display a name rather than
the ID is to have more than one column in the rowsource
(with ID as the first column), then set the column width
for the first column to 0. This will cause the combo box
to display column 1, even though it is storing the column
0 value in the bound field.

One side note, many prefer to not do this, but rather
show an additional text box bound to the name field in
the lookup table, because it works better for filtering
and sorting.

Hopefully this helps.

-Ted
 
Back
Top