CheckBox Help

[Chris]

I have an ingerited database with a form that populates with data from a
table. The SQL looks like this:

SELECT Tbl_PIP.InspectionID, Tbl_PIP.[Hotel ID], Tbl_PIP.Date, Tbl_PIP.Need,
Tbl_PIP.Item, Tbl_PIP.Category, Tbl_PIP.Location, Tbl_PIP.[D-C Reference],
Tbl_PIP.Comment, IIf([Need]=True,True,"") AS Need2, Tbl_PIP.Phase,
Tbl_PIP.PIPID, Tbl_PIP.[Top Priority], Tbl_PIP.[Required Product Reference],
Tbl_PIP.Commodity
FROM Tbl_PIP
WHERE (((Tbl_PIP.Item) Is Not Null) AND
((Tbl_PIP.Category)=[Forms]![Frm_PIP_Inspection]![cbo_Area]) AND
((Tbl_PIP.Location)=[Forms]![Frm_PIP_Inspection]![cbo_Location]) AND
((IIf([Need]=True,True,"")) Like
[Forms]![Frm_PIP_Inspection]![Frm_PIP_Inspection_Subform].[Form]![Text25] &
"*"))
ORDER BY Tbl_PIP.Commodity, Tbl_PIP.[D-C Reference];

My issue is that I would like to add a checkbox that once it is selected,
will automatically mark all items displayed as Need = True. I was able to
write some code that helped do this but it only checked the first item out of
a 10+ item list. Any help or suggestions would be great!