Attendance Records

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?

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.

--
Duane Hookom
MS Access MVP
--

"accessboy" wrote in message
news
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?