Change checkbox value

T

Trevor

I have a membership database that has a checkbox to
record if the member is current. I want to change all
values to false without manually changing each record.
I am fairly basic with access but I am sure there must be
a simple macro to achieve this.

Any help would be appreciated.

Regards
 
A

Allen Browne

Use an update query.

1. Create a table into your table.

2. Change it to an update query: Update on Query menu.
Access adds an Update row to the grid.

3. Drag the Yes/No field into the grid.
In the Update row, enter:
False
In the Criteria row, enter:
True

4. Run the query.
 
V

Van T. Dinh

A quick Query should do. Something like:

UPDATE [YourTable]
SET CurrentField = False

If you need to run by code, use DoCmd.OpenQuery or
CurrentDb.Execute Method.

HTH
Van T. Dinh
MVP (Access)
 
Top