Question about subforms and mainforms.

[SpiritedAway]

Hi all

I have a master/child link between my mainform and a continuous subform - the subform has a check box control which is ticked by the user when an action in that record is resolved.

What I'm trying to do is enable a button on my mainform only when ALL the records in my subform are True (i,e all the records in my subform are resolved).

So, for exampled, if I have 5 records in my subform - the checkbox in all 5 records need to be ticked (i.e True) for the button on the mainform to enable.

I can get it to work for one record - but for multiple records is proving elusive.

Any ideas as always is gratefully welcomed.

Using A2007

Thanks

 

[gemma-the-husky]

instead of checking that all the records are ticked, do it the other way

as long as any records are not ticked, then dont enable the button