Select All CheckBox
Posted on 2003-11-24
Access 97 ..
I have a continuous form containing a number of records, each of which has a CheckBox linked to a field [fldUpdate].
I also have an update query that updates the records where the above checkbox = True.
How can I add a further checkbox to the form that will act as a 'Select All' box, i.e. when the Select All checkbox is set to True, the checkbox on each record is also set to True - when the Select All checkbox is set to False the checkbox on each record is also set to False.
I have little knowledge of VB, so please comment any code provided.