G Guest Dec 9, 2003 #1 I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY RECOED
W Wayne Morgan Dec 9, 2003 #2 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 tinakenney said: I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY Click to expand... RECOED
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 tinakenney said: I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY Click to expand... RECOED
L Larry Daugherty Dec 9, 2003 #3 You also need to find and use your shift key properly. ALL THAT SHOUTING IS CONSIDERED RUDE! Open your form in design mode and set the data source for the checkbox to FALSE. HTH -- -Larry- -- tinakenney said: I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY Click to expand... RECOED
You also need to find and use your shift key properly. ALL THAT SHOUTING IS CONSIDERED RUDE! Open your form in design mode and set the data source for the checkbox to FALSE. HTH -- -Larry- -- tinakenney said: I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY Click to expand... RECOED
K Kristin Kuntze Dec 11, 2003 #4 tinakenney said: I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY Click to expand... RECOED
tinakenney said: I NEED TO RESET CHECK BOX TO FALSE EVERY TIME A FORM IS OPENED FOR EVERY Click to expand... RECOED
