Reset Yes/No Boxes

[bsdixon]

I have a query that has a yes/no check box. I want the yes/no boxes to reset to "no" each time I open the query. I am opening the query with a click button on a form. Once the query opens I then want to select which records I need.

Is there a code that will either clear the boxes or reset the filter?

Thanks.

 

[Rich]

Use an Update query to re-set the yes/no values. Having said that you shouldn't enter/edit records directly through a query, use a form instead

 

[bsdixon]

Thanks for the response. The data will now be entered in the form instead of the query.

I cannot get the update query to work. In the design view of my query, i selected update query. I then put update to No in the yes/no column. When I ran the query, only this column shows up. All of the other information is gone.

What am I doing wrong?

 

[Rich]

To Run the query you have to click Run on the toolbar, or use code, if you simply View the query it will only show the field/s records that will be updated, assuming you Run the query of course