Date selecting box for an event
I have no idea on how to accomplish a project I am planning to create. Is it possible to use a date selecting box or use a date range to limit a combo? How can I accomplish this? I want to create a form so that I can see members who is no longer active in an event on a certain date range and select from it. Individual ID, Name of the member and position must be in one main table.
Further each table should contain multiple records of the same person during various ranges of dates. This will serve as reference for the start and end date of joining activities. This is to select who remains every time I add someone to any event.
PLEASE HELP!! Thanks in advance!