automatically fill in check boxes in limited recordset

[emcf]

morning all,

hopefully one of you can point me in the right direction here....

I have a form with a subform (default view is single form) attached. what i need to do is when an on update event comes out true i need to force a checkbox on the subform to become true. I can make it do this for the current record on the subform but i need to make all the checkboxes in records shown on the subform to show it as well.......i presume i'll need to use the recordset stuff.........any takers???


thanks in advance!

 

[dcx693]

You may not need to use "the recordset" stuff, but you can if you want to.

You can actually run a parameter update query to update those checkboxes to selected. The query must be called from the On Update event of the subform. The query needs to reference one or more fields in your form and/or subform to tell it exactly which set of records it needs to update. For example, "all students who are taking History 101 this semester".