Yes/No Checkbox Question

[Richard]

Hi All,



In my database I have several records and each record has a Yes/No field called verified.

When I create a query to pull information from the database using date ranges I have this information in a form and in that form it shows all the records within that date range.

EXAMPLE:

Fname, Lname, Address, Phone, Fax, Verified
Joe, Blow, 1121 Church-Hill, (555)555-5555, (555)555-5556, Y/N


What I would like to do is create a single checkbox on the header and once it is clicked it will select every record that is displayed as if I verified all of them.

Reason for this is once the data has been viewed I do not want this information displayed again if I where to recall the same date ranges.

Can anyone help me please?

[Zigzag]

It sounds as if you need to add a button to your form that runs an update query.
The update query needs to be based on the query that your form is based on.

[Richard]

Thanks ZigZag the Update Query worked. I just need to tweek it to set the checkbox to true on the data that is being displayed and not the entire database but I am sure I can figure that part out.

Thanks again man.

[Zigzag]

Post again if you have any problems with that.