CheckBox question

[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

 

[Guest]

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

 

[Douglas J Steele]

It's almost always faster to use SQL than VBA. Run an Update query, then
requery the subform.

 

[Guest]

Both of you,

Thanks for the reply. You have confirmed what I thought.

Alastair