Great tutorial I would like to know if you can steer me in the right direction I am wanting to convert this calendar database to a calendar where there would be a form to generate employee  shifts and would display person1 9-5p, person2 11a-6p, etc. in the form there would be a dropdown box with the employees and the different shifts they could possiably work. you would select the day, person, and shift and all that would display in the calendar to be handed out to the employee's, would this siminar be hard to change to accomidate this?

---

Reply from Richard Rost:

If you know that you have distinct shifts, then you could construct a form to just select people for those shifts, sure. Let's say you have three shifts (1st, 2nd, 3rd) and you want to set it up for the week (7 days). Just make a total of 21 unbound combo boxes on a form. Select an employee for each shift, then make a command button insert all of those people into your schedule table using a recordset. If you want to be able to have multiple people for each shift, then make multiple combo boxes for each shift.