Check off attendees from the entire list of employees?

[Lostguy]

Hello! Here's the setup (Access 2003):

tblEmployee (EmployeeIDpk, LName, FName)
tblEvent (EventIDpk, Event, EventType, EventPeriodicity)
tblEmployeeEvent (EmployeeIDfk, EventIDfk, EventLocation,
EventStartDate, EventEndDate)

Here's the scenario:

Starting on EventStartDate and ending on EventEndDate at
EventLocation, an Event (which is an EventType) happened for Employee
(s). This event is scheduled to repeat every EventPeriodicity.

So I can use this for one-time or recurring training, evaluations,
dental exams, whatever.

As it is on the form, you enter the dates, select the event, enter the
location, and use a dropdown to select the person.

This is good except for events (i.e., training classes) where you have
multiple people on the same date.

I would like to make this so you enter the dates, event, location, but
instead, you get a list of every employee from the tblEmployee, and
then use checkboxes to select whether they attended. So going down the
list and checking off would be faster than going through employee-by-
employee using the combo box.

How do I set this up to store the date, event, event location, and the
checked employeeID for checkbox method?

(I get it for "one date and one check", but "one date and many checks"
has me stumped. Thanks!

VR/
Lost

 

[Arvin Meyer [MVP]]

Use a subform with a combobox to select event participants from your list.
There will be 1 record for each person in the subform.