Sort of Autolookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with an autolook up field. Looks up to an employee table. The
employee number, Last, and first name. Right now when I am entering data it
sorts the autolookup by employee number. Is thier a way to change that so it
is done by last name? Thnaks in advance. Jay
 
I have a table with an autolook up field. Looks up to an employee table. The
employee number, Last, and first name. Right now when I am entering data it
sorts the autolookup by employee number. Is thier a way to change that so it
is done by last name? Thnaks in advance. Jay
Click to expand...

First off... DON'T enter data into table datasheets. Tables are for
data storage, and table datasheet view is for debugging and design
only, not for routine use.

Instead, create a Form based on your table. You can use the Combo Box
Wizard from the toolbox to create a combo box to look up an employee;
it's best to base this on a Query which has the EmployeeID as the
bound column, but displays

[LastName] & ", " & [FirstName] & " " & [MiddleName] & " (" &
[Department] & ")"

so that if (as I once did) you have two colleagues with the same exact
name in two different departments you can choose which you want.

Once you build this Query (sorting by lastname/firstname) you can use
the Combo Box wizard to have it look up the employee based on the
selection.

John W. Vinson[MVP]
 
Back
Top