Access 97 beginner

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I've created a simple database for Helpdesk tracking using
Access 97. The database has two tables - Employee &
Tracking. I created a form that enters information into
Tracking, but have been trying to get the "Name" combo box
on the form to bring up data from the Employee table (to
save typing). The Employee table has two columns - Lname
& Fname. I can see both columns when I use the drop down
box, but only the last name will appear on the screen when
selected (and only the last name is entered on the
Tracking table).

Any help would be appreciated.
 
Thanks, that's just what I needed!
-----Original Message-----
While ComboBoxes can display a number of columns, they
only store one to use for updating and this is what is
displayed when selected.

In the properties, you can select the Bound (or saved)
column, as well as set the column widths.

I would use this for my ComboBox:

RowSourceType: Table/Query
RowSource: SELECT [tblEmployees].[LastName],
[tblEmployees].[LastName] & ", " & [tblEmployees].
[FirstName] FROM tblEmployees ORDER BY [tblEmployees].
[LastName], [tblEmployees].[FirstName];
ColumnCount: 2
ColumnHeads: No
ColumnWidths: 0.0", 1.5"
BoundColumn: 1

This will pull and store the LastName field but not
display it. Instead, the Last-comma-First names will
display.

Personally, I would use a different identifier than the
LastName because there are too many duplications, even
within small companies.

Hope this helps!

Howard Brody

-----Original Message-----
I've created a simple database for Helpdesk tracking using
Access 97. The database has two tables - Employee &
Tracking. I created a form that enters information into
Tracking, but have been trying to get the "Name" combo box
on the form to bring up data from the Employee table (to
save typing). The Employee table has two columns - Lname
& Fname. I can see both columns when I use the drop down
box, but only the last name will appear on the screen when
selected (and only the last name is entered on the
Tracking table).

Any help would be appreciated.
.
Click to expand...
.
Click to expand...
 
Back
Top