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

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.

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

Kyle