Change checkbox value

[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

 

[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.

 

[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)

 

[Guest]

Thanks heaps
I was sure it had to be simple but I couldnt find an
answer.

Regards