Reset a form's Yes/No checklist on loading or on closing

[louise]

Hello,


I have a Yes/No field in my table that serves as the basis for a checklist -- [BeOnEmailList]. The default value is set to "yes" and all records are "yes" at this point.
Then, on a form, I have a check box so records can be dropped from the email list (i.e., changed to "no".) and a button on the form opens a query that displays the chosen emails (which are then copied and pasted into Outlook).

What I would like to do is set all records back to "yes" again after the form closes OR set them all to "yes" as the form opens.

Can you give me some idea how to do this? Am I correct in putting the field in the table?

Thanks!

[June7]

Run an UPDATE action:

CurrentDb.Execute "UPDATE tablename SET fieldname=True"

Is this a multi-user database? If so, this field in table will not work. Multiple users will conflict.

[louise]

Hello,
thanks for your response. I have a couple of questions about it:
First, I don't think it's what you would consider a multi-user db. There are two people using it, but we use it one at a time from Dropbox. So, we are always using the same db. Does this fall outside of what you were referring to?

Second, where should I put the update action? On load of the form? On Open? On close of the form?

Finally, is "CurrentDb" the actual name of my db? and is it the full long name, including location, etc.?

Can you suggest a better way to do this, perhaps one that doesn't save the field unnecessarily in the actual table?
thanks,

[June7]

The only other alternative I can think of involves a list box and VBA, review: http://allenbrowne.com/ser-50.html

As long as there is only one user at a time selecting records with the checkbox, should be okay.

Use CurrentDb just like that - it is an intrinsic constant and Access knows what to do with it.

Figuring out what event to put code into is the tricky part - form Open or Close should do it, take your pick.

[louise]

Thank you so much!
Used the CurrentDb etc and it worked just fine.
I appreciate your help!