Subform clear data

[Michelle]

I have a Form that contains Employee Information (their employment status,
and for viewing and printing reports) and a subform showing each “Line†the
employee has worked on. Each “Line†contains many “Workstations†the
employee has been trained on. So basically I have multiple subforms for each
employee.

My problem is that each subform will have certain boxes checked for each
“Line†but when a new “Line†is added for that employee I would like the
checkboxes to be cleared out so the next “Lines†checkboxes can be updated.

For instance:

Lori works on the “JS†Line, “Workstation #3†and has achieved 4 squares (so
all four squares are checked).

She also has been trained on “JS†Line “Workstation #1†but only has
achieved 2 squares.

I would like the checkboxes cleared out so when the user creates a new
subform (or new record in that subform) for Lori on “Workstation #1†they can
check 2 squares only.

Is there a way to clear out the checkboxes when a new subform record is
added. Thank you.

 

[kingston via AccessMonster.com]

How have you set up your data tables? What are the fields in a "new record"
and what do you mean by a user creating a "new subform"? If I understand
correctly, I recommend setting up your data with three or four tables:

1) Employee basic information
2) Employee proficiency? information (these are the check boxes)
3) Line information
4) Workstation information

Line and workstation may be combined for this problem but you may have a need
to have them separate for your overall scheme. Now when you add a record, it
is added to table 2 and that record will contain the EmployeeID,
Line/WorkstationID, and four empty checkboxes or a field that accepts a
number ranging from 0 to 4 (and a default value of 0). hth

 

[Michelle]

I set up a new table for "Squares" and it worked. Thank you!