Combo vs List Boxes

  • Thread starter Thread starter Rick West
  • Start date Start date
R

Rick West

When I use a List Box to select data for filling in a
column in a table it works fine. The table columnID
(autonumber)is passed to the receiving table and the list
box shows the selections in descriptive English from
column #2 & #3.

But, when I try to do the same thing with a Combo Box
(want to use a Combo Box because I understand a user can
either select from a list or type in their own data)the
columnID (autonumber)is all that is visible in the Combo
Box after the selection is made?

Example: Table1, ColumnID, Person's Name
I want the Combo Box to show the persons name and pass
the ColumnID to the receiving table. Now the ColumnID
shows after the name selection is made.

Any help is appreciated, thanks.
 
The text box shows the value from the first non-hidden
column of the selected item from the dropdown list. Your
select statement should specify the name column then the id
in order to see the name appear in the text box. In order
to carry the id through as the value, you will need to
increment the BoundColumn property.

Hope That Helps
Gerald Stanley MCSD
 
You need to set the Column Count to how many column to display, the default
is 1, which means it will only show the first column in the RowSource query.
Place the cursor in the Column Count box in the Properties window and hit
F1 and the Help function should display info about this property.

There is also a property called Column Widths that will let you specify the
width of each column. It is decimal numbers separated by semicolons. You
would enter for example 0;0.5. That would hide the first column and display
the second column 0.5 inches wide.
Again, just place the cursor in the box and hit F1.

Access' built-in help has quite a lot of information, try using it.

Ragnar
 
Back
Top