Select All Button

[magmike]

I am working with a subform (ContactList2b) on a tab (Contacts). The
form is a continuous form and each record has a check box next to that
is tied to the field [ContactSelect]. The purpose of the box is to
mark records to work with (i.e. to delete multiple records or email
multiple records). How can I code a button to select all that are
visible on the form?

 

[Mark]

Open a recordsetclone of the form's recordset and loop through setting the
flag true then close the recordsetclone and requery the form.

Alternatively you could contruct a sql statement that selects the records
you want and updates the flag.

 

[magmike]

Open a recordsetclone of the form's recordset and loop through setting the
flag true then close the recordsetclone and requery the form.

Alternatively you could contruct a sql statement that selects the records
you want and updates the flag.

I am working with a subform (ContactList2b) on a tab (Contacts). The
form is a continuous form and each record has a check box next to that
is tied to the field [ContactSelect]. The purpose of the box is to
mark records to work with (i.e. to delete multiple records or email
multiple records). How can I code a button to select all that are
visible on the form?- Hide quoted text -

- Show quoted text -

Please forgive me, but I am a novice. Could you walk me through doing
all that?

Thanks!
magmike