S
Secret Squirrel
I have a form & subform to track my employee training. The main form shows
the employee and the subform shows the training records in a continuous form.
The fields on the subform are:
Material
Size Range
Tolerance
Trained - Yes/No Checkbox
Each subform has 4 records for each employee but only one of those records
can have a "true" value in the checkbox. The other 3 have to be a "False"
value. How can I set it up where if a user checks one of the checkboxes in
one of these 4 records to set it to "true" it won't allow it if one of the
other 3 checkboxes are already set to "true"? Basically only allowing 1 of
these 4 records to have a "true" value in the checkbox.
Any help is greatly appreciated.
SS
the employee and the subform shows the training records in a continuous form.
The fields on the subform are:
Material
Size Range
Tolerance
Trained - Yes/No Checkbox
Each subform has 4 records for each employee but only one of those records
can have a "true" value in the checkbox. The other 3 have to be a "False"
value. How can I set it up where if a user checks one of the checkboxes in
one of these 4 records to set it to "true" it won't allow it if one of the
other 3 checkboxes are already set to "true"? Basically only allowing 1 of
these 4 records to have a "true" value in the checkbox.
Any help is greatly appreciated.
SS