K
Kellie
I have a Form to display employee information with a subform that displays in
datasheet view. In the subform I may have many records for the employee that
relate to courses attended. There is a check box for ‘course1’ and a check
box for ‘course2’. When at least one ‘course1’ and one ‘course2’ type courses
have been attended I need a ‘funding’ checkbox on the main form to be set to
True so I can report on those employees who are now eligible for funding. I’m
not sure how to code this because the ‘course1’ may be checked on one
record/row and the ‘course2’ may be checked on another record/row in the
subform
datasheet view. In the subform I may have many records for the employee that
relate to courses attended. There is a check box for ‘course1’ and a check
box for ‘course2’. When at least one ‘course1’ and one ‘course2’ type courses
have been attended I need a ‘funding’ checkbox on the main form to be set to
True so I can report on those employees who are now eligible for funding. I’m
not sure how to code this because the ‘course1’ may be checked on one
record/row and the ‘course2’ may be checked on another record/row in the
subform