Re-set value of a check box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Bob,

Do you mean you did another Update Query? What do you mean by "did not
work"?
 
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

Steve Schapel said:
Bob,

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

--
Steve Schapel, Microsoft Access MVP

Bob said:
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.
Click to expand...
Click to expand...
 
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.
 
Back
Top