B
Bruce
I have a database for recording training information.
There is a main form to record session information
(subject, instructor, etc.), and a subform to record
attendance. The form and the subform are each bound to
their own table. The subform's table is a junction table
between the Employees table and the Sessions table (each
session has many attendees; each employee attends many
sessions). The subform (and its underlying table) has
fields for name, date, and a check box
labeled "Verified". I would like a way of having the
default value of the check box be "No", but with a way of
setting the check box value to "Yes" for all attendees.
The reason is that sometimes the manager will set up in
the database a training session for a specific listed
group of employees, in which case attendance is not
verified until later, when the session is complete. In
other cases the training record will be handwritten, in
which case attendance can be verified as the training
session is being entered into the database. I know I can
set the default value of the check box in the table, but I
would like to be able to change it on the form (with a
command button?), so that in the second case mentioned
above (handwritten record), all names entered will
automatically have a check mark in "Verified".
In a possibly related question, I would like for the
default date next to each employee's name to be the same
as for the previously listed employee at that session.
90% of the time that is the case; sometimes, though,
because of different shifts, etc., it is not, which is why
I cannot just put the date into the general session
information.
There is a main form to record session information
(subject, instructor, etc.), and a subform to record
attendance. The form and the subform are each bound to
their own table. The subform's table is a junction table
between the Employees table and the Sessions table (each
session has many attendees; each employee attends many
sessions). The subform (and its underlying table) has
fields for name, date, and a check box
labeled "Verified". I would like a way of having the
default value of the check box be "No", but with a way of
setting the check box value to "Yes" for all attendees.
The reason is that sometimes the manager will set up in
the database a training session for a specific listed
group of employees, in which case attendance is not
verified until later, when the session is complete. In
other cases the training record will be handwritten, in
which case attendance can be verified as the training
session is being entered into the database. I know I can
set the default value of the check box in the table, but I
would like to be able to change it on the form (with a
command button?), so that in the second case mentioned
above (handwritten record), all names entered will
automatically have a check mark in "Verified".
In a possibly related question, I would like for the
default date next to each employee's name to be the same
as for the previously listed employee at that session.
90% of the time that is the case; sometimes, though,
because of different shifts, etc., it is not, which is why
I cannot just put the date into the general session
information.