Re-set value of a check box

[Bob K]

I need to reset the value of a check box (Dues Paid) to False in about 300
records. The check box is on a form bound to a field in the database table. I
hope to do this with a macro bound to a Command Button which will be on the
Switchboard page.

 

[Steve Schapel]

Bob,

Make an Update Query to update the value of the Dues Paid field in your
table to 0 and then use an OpenQuery action in your macro to run the
Update. Please post back if you need more detailed help with this.

 

[Bob K]

That worked for clearing the check boxes. Now I need to re-check some of them
if another check box = true. Some thing like: If [Dues Paid Again] =true then
[Dues Paid] =true This did not work.

 

[Steve Schapel]

Bob,

Do you mean you did another Update Query? What do you mean by "did not
work"?

 

[Bob K]

I wrote 4 Update Querys. 3 of them worked the way I expected.
What I have are 3 check boxes, Dues paid, Dues paid again, Ski trip. My idea
was to clear the dues paid box (this worked) and clear the ski trip box (this
worked) and I attempted to write a macro to look at the value of 'dues paid
again" and if it 's value was true then the value of "dues paid would be
re-set to true.
Something like this: IF([dues paid again]=-1 THEN [dues paid]=-1) IFELSE =0

Bob,

Do you mean you did another Update Query? What do you mean by "did not
work"?

--
Steve Schapel, Microsoft Access MVP

That worked for clearing the check boxes. Now I need to re-check some of them
if another check box = true. Some thing like: If [Dues Paid Again] =true then
[Dues Paid] =true This did not work.

 

[Steve Schapel]

Bob,

The SQL view of the Update Query will look something like this...
UPDATE YourTable SET [dues paid] = -1 WHERE [dues paid again] = -1

The only way a macro would be implicated would be if you needed to
automate this process, in which case you would use an OpenQuery action
int he macro to run the Update.