selecting from a long list

  • Thread starter Thread starter lynn atkinson
  • Start date Start date
L

lynn atkinson

I have a combo box which looks up the employee ID and
stores this in the field (number) but also displays the
employee surname and forename for easy recognition.

ie 222 Smith John
and when this entry is selected, 222 is stored in the
field.

However, since we have 800 records in the employee table,
is there a way of 'speed scrolling' ie pressing 's' and it
will go to the first surname starting with s? (the list is
sorted on surname)

At present this does not work as, I assume, the first
column is a number.
If I change the columns round so the surname is the first
column, then I can press 's' to select the first 's', but
the database tries to store the name (ie contents of the
1st column) and is rejected as this is text not a number.
What am I missing?
 
Set the Column Widths property such that the Surname is the first field that
has a non-zero width.

Assuming 3 columns: EmployeeID, Surname, and FirstName, set the Column
Widths to (say):
0"; 1"; 1"
Leave the Bound Column as 1, i.e. it will store the first column.
 
The comboBox's BoundColumn is the property that tells
Access what to store so you need to change it in line with
the column that shows the employeeId.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top