Combo Box

  • Thread starter Thread starter Pete Smith
  • Start date Start date
P

Pete Smith

Access 2000
I am using a combo box in one table to fill a field with values from
another table. There are only 3 fields in the 2nd table Identifier,
first name, last name. Identifier is an autonumber. When I activate
the combo box I can see both the first and last names in the drop down
box, but when I make the selection only one field shows. How do I get
both first and last names to show? I am just starting out trying to
teach myself Access.
TIA

Pete Smith
 
You can display a number of fields in a ComboBox but it
can still only be bound to one field in your table. If
you look at the properties for it:
RowSourceType: Usually Table/Query
RowSource: The SQL statement to pull the data. The SQL
Click to expand...
statement for your table might be: "SELECT [tblTable].
[Identifier], [tblTable].[FirstName], [tblTable].
[LastName] FROM tblTable;"
ColumnCount: How many columns will the ComboBox have?
Click to expand...
Note: this is not the number of columns that will be
displayed. Often, you my want to have a store a value
butnot display it . . . like displaying the FirstName and
LastName but storing the appropriate Identifier
ColumnHeads: Are the column headers displayed?
ColumnWidths: this is where you determine which fields
Click to expand...
are displayed. For the above example, you might set your
widths as: "0,1.25,1.25"
BoundColumn: Which i\column is the one whose values you
Click to expand...
want to store? You would choose 1 for the [Identifier]
field.

Hope this helps!

Howard Brody
 
Back
Top