Using a combo box to fill in other fields

[mccluein]

I have a form with a combo box for Employee ID#. When I click the drop down arrow all employee ID#s are shown along with their corresponding First_Name, Last_Name, and Store_ID fields. However when selecting the Employee ID# the other fields are not automatically filled in.



How can I make the corresponding fields; First_Name, Last_Name, and Store_ID, be automatically filled in on a new record once the proper Employee ID# is selected from the combo box?

[pbaldy]

Note the caution against storing the other data:

http://www.baldyweb.com/Autofill.htm