Attendance Records

[Guest]

Trying to develop a database that will track employee attendance. I have a
form that has dropdowns, and a rolodex to select employees. I would like to
insert a subform to track sickdays. The subform would have to be linked to
the employee selected from the dropdown. So as a new employee is selected, a
new subform would open. What is the simplest way to accomplish this?

 

[Duane Hookom]

Create a continuous subform that displays your sickdays table. Place the
subform on a main form that has a combo box in the form header with a Row
Source of all employees. Set the Link Master/Child properties to the combo
box and the employee primary key field from the subform.