set check box to false

[tinakenney]

I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY RECOED

 

[Wayne Morgan]

Please DON'T type in all caps. It is hard to read, is bad manners, and is
considered SHOUTING.

In the Open event of the form run an update query that resets the field
feeding the checkbox to False.

strSQL = "UPDATE Table1 SET Table1.CheckBoxField = False;"
CurrentDb.Execute strSQL, dbFailOnError

--
Wayne Morgan
Microsoft Access MVP

I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY

RECOED

 

[Kristin Kuntze]

I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY

RECOED