I have group of employees for which I want to add daily working hours, leave sick leave etc. I want to select the start of week using a combo box (done already). This should then populate a subform in datasheet view, filled with all active employee's name, number and the relevant fields such as normal hours, sick,overtime etc.
The sequence is then:
Select week
Fill subform with active employees data from employee table
Edit different working hour data for each employee
The sequence is then:
Select week
Fill subform with active employees data from employee table
Edit different working hour data for each employee