Create new record form based on combo box

[farewinners]

I have two different tables. The first table has a list of all "employees". On my other table "vacation" I have a list of all the days an employee has used vacation and how many hours. I have a query that calculates who is eligible to use vacation called eligible list". I want to pick a name from a combo box of employees that are on the "eligible list" and add a new record based on who I have chosen. For example I pick Charlie Smith from the list of "eligible list" and enter the date and time he was on vacation. I want the form to fill in the other fields of the record with Charlies employee number. Thank you in advance.

 

[alansidman]

Look at this link:

Autofill