farewinners
New Member
- Joined
- Jun 12, 2013
- Messages
- 11
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.