Select multiple dates to populate a "Leave Table"

[WickidWe]

I need to make a form
It will contain a team member Combo
EmpID textbox
Date Selection
Leave type textbox
and a roster textbox



I need to be able to select a team member
then in the Date selection select multiple dates and insert all records into a table
one row per Date Selected. Is this possible or is there a better way I could accomplish this?

[Bob Fitz]

IMHO you only need one record, but you need two fields in the table to store the start date and end date of a persons leave.