Print or edit filtered records

[Bryan]

I have a DB that has thousands of records with addresses and other personal
data. We use this to perform target mail outs. Currently we filter the
records from a form until we have the desired records we want to mail to.
Then we go down the list and check a yes/no box so we only print the filtered
records. Once the records are checked we run the checked records through
update queries to update who we mailed to, what we mailed ect... and then we
print the reports. Is there a way to set up a button to check the filtered
records? Or is there a way to check the first record and hold shift to check
the last record?

 

[JA Peachrose]

You can make a new update query or copy the current one you have that run
your form and make it an update query ---
either way you go you will add a field in the query that will check the
boxes you want using this code:
iif([checkbox_field] is null, -1,0)



-1 means the yes/no field is checked = yes
0 means the yes/no field is not checked = no