CheckBox question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

If I have a subform on a form which contains a CheckBox, how can I loop
through all the records in the subform to change all the records' CheckBox to
True?

where the main form is Form1, The subform subForm1 and the CheckBox chk1 and
the recordsource for the Form is Query1.

Do I loop through the recordsource of the subForm1, or do I run an update
Query and change the values and then requery the sub form?

Thanks again.

Alastair MacFarlane
 
Hi,
yes either run an update query or and update sql statement to do whatever
you want to.
Then requery the subform to reflect the results.
HTH
Good luck
 
It's almost always faster to use SQL than VBA. Run an Update query, then
requery the subform.
 
Back
Top