Combo Box

  • Thread starter Thread starter Robert Raley
  • Start date Start date
R

Robert Raley

Access 2003

I am using a combo box with 2 columns. I store the data from the first
column in a table. When I am viewing the form I am now viewing the data
from Column 1 in the field. I would like to view the name in field.

Thanks

Bob
 
Look at the properties of the combo box in the form's design view. Make
sure it's set for two columns, and make the column widths 0" and 1" to hide
the first column and show the second.
 
I am sorry. I am happy with the combo drop down. What I want to see when I
am reviewing the form is the City name in the field not the city id number.
The id num is stored in the table.

hope I have been clearer now.

Thanks

Bob
 
I am sorry. I am happy with the combo drop down. What I want to see when I
am reviewing the form is the City name in the field not the city id number.
The id num is stored in the table.

hope I have been clearer now.

Thanks

Bob
Click to expand...

You were clear the first time.
And the answer you received was correct.
Set the Column widths property of the combo box to:
0";1"
Set the Bound column property to 1
Set the column count property to 2

The first column (hidden) is the ID number and will be stored in the
table.
The second column (the name column) will be what you see in the combo
box.
 
Robert said:
Access 2003

I am using a combo box with 2 columns. I store the data from the
first column in a table. When I am viewing the form I am now viewing
the data from Column 1 in the field. I would like to view the name
in field.
Click to expand...
The correct answer is that you should relate the table containing the ID and
the table which contains the name, address, phone, etc.
Use that query in your forms and reports. Show the name from the Name table
and don't show the ID field from the "main" table.
 
Back
Top