Set Yes/No field to No (1 Viewer)

[snorf3]

I have a yes/no field that is used as a criteria to run an append query. When the field is set to yes, the record is appended to another database.

Is it possible to set the field back to "No" after the query is run, so that it needs to be selected as "yes" before being appended again?

Right now, once I set it as yes, it stays as yes unless I manually go back and set it to No. I'd like this to be done automatically.

The append query is run from a command button on my form. Is there some code I can add in the event procedure of the command button that will automatically reset my yes/no field to "No"?

Thanks for all help!

 

[pcs]

create an update query that resets the yes/no and then execute it after your append query.

hth,
al