Auto Fill

[Jeremy]

I have a form with the following information: Employee
First Name, Employee Last Name, Employee Extension,
Employee Cell Number. I have over 100 Emplyee's in my
list and do not like using the mouse wheel to scroll
through them. I set up the database, so I am familiar
with it, but I Would like to know if anyone has any ideas
how to set the Employee's First Name cell up so that it
auto fills and pulls the other info in as well. Thank you

 

[John Vinson]

I have a form with the following information: Employee
First Name, Employee Last Name, Employee Extension,
Employee Cell Number. I have over 100 Emplyee's in my
list and do not like using the mouse wheel to scroll
through them. I set up the database, so I am familiar
with it, but I Would like to know if anyone has any ideas
how to set the Employee's First Name cell up so that it
auto fills and pulls the other info in as well. Thank you

Put an unbound Combo box on the form to find the record. The toolbox
combo wizard will offer this as an option - "use this combo to find a
record".

Do include first and last name - with a hundred employees you surely
have at least a couple with the same first name; even first and last
can easily duplicate (I know three Fred Browns).