check Box on Form Multi-part question

[Chris66]

I don't know if this is possible or not, I hope it is. I am going to have a table with about 2K records on it. Each record represents a part that we are short on in production over the next five days. Each part has a planner code associated with it, each planner code can have numerous part numbers with it. I currently have a check box with the Planner code and another check box with the Part number.

Is there a way to set the Planner Check box to appear only once on the form? (Planner Code A1 would have only 1 check box)
then, Can you set the check box for the planner code so that when you check the Planner checkbox, all the part number within that Planner code are checked?
PC P/N Date
A1 123 5/01
A1 123 5/02
A1 123 5/03
A1 989 5/01
A1 989 5/02
A1 989 5/03
B1 456 5/01
B1 456 5/02
B1 456 5/03
B1 789 5/01...and so forth

[OBP]

It would depend on the form's layout, if you have a continuous form showing the records the way that you have listed them on here, then I think not. If you had the A1 in a main form (Combo maybe) and all it's part numbers in the sub form then you could have the check box on the main form with some VBA to update the individual checkboxes in the table or even an "update query" to do it.