uncheck on close - help

[johnlatona123]

hi all,

i have yet another unique issue that i could use some help with.

i have a form that contains a sub-form that has a check box in it for each of the numerous records. the sub-form is a continuous form.

i want to do a "on close" unchecking of any checked boxes

so how can i tell access 2010 to uncheck my checkboxes if they are checked on close?

please advise.

thanks!

 

[John Big Booty]

I'm presuming your sub form is bound to a table, so if you put the following code in the On Close event of your form;

Dim strSQL As String

strSQL = "UPDATE YourTableName SET YourTableName.CheckFieldName = False;"

DoCmd.[URL="http://msdn.microsoft.com/en-us/library/office/ff194626.aspx"]RunSQL[/URL] strSQL

 

[boblarson]

If the checkbox is bound to a field, then just run an update query to set them all to false

Update TableNameHere Set CheckBoxFieldNameHere = False

 

[John Big Booty]

 

[johnlatona123]

thanks guys, that was the solution to my problem, much obliged.