clear all entries in 1 field within a table

[KyleB]

I'd like to create a command button, most likely placed on the data entry form, that goes through the master table and clears the check boxes from 1 field for every entry in the table. This checkbox field is used expressly for determining what data is currently active, anything without a check in this box is old data, this way I can search and isolate currently active information. Suggestions? Update query?

Kyle

 

[Travis]

if all you want to do is clear it, create an Update Query to set that field to the value that you want.

From a Command Button you can use:
CurrentDB.Execute "YourQuery's Name"

To run the Update Query.

 

[KyleB]

Perfect, that's exactly what I wanted, just wasn't sure how to go about making it occur. Thanks for the help.

Kyle