Access Access 2007 Form Autofill help

[dvorasnell]

I have a form in Access 2007. Basically, I am keeping track of books, which employees will check out and return. To this end, rather than type employees names, dept, phone etc over and over again, I want to lookup employees based on, say, phone number and have the rest of the data autofill, such as first & last name, department & manager.

I have imported the data from HR and have a separate table with this data. '

Can you help me figure out how to autofill all other fields based on phone extension?

Currently, I have a combo box looking up phone extention. I can't remember if I need combo or list boxes for the other fields and how to write the code.

Any help you can offer will be most appreciated!!!!!

 

[knkpatrick]

Did you get it figured out

I am trying to do something similiar, and I am not finding direction to do so. Did you get it figured out? If so what did you have to do to accomplish this?