On checkbox false run update query

[Pusher]

Hi all,
I need to start an update query on deselect or unchecking a check box. I made a mechanism for auto checking this box if there is a result from another query – this query checks to se if there is another record that has this box checked. If there is, the new record has this box checked. But if I UNCHECK it clears all old records so this checkbox is clear from this point on in all the records. How do i do this?
Thanks

 

[MarkK]

Huh? Does that makes sense? How do you do what?

 

[RossWindows]

Take a look at the checkbox's BeforeUpdate event.
In that event, write code to test for checkbox.Value
Something like this might do the trick

Select Case checkbox.value
     Case True
          CurrentDB.Execute "Your SQL statement here;",dbFailOnError
     Case False
          CurrentDB.Execute "Your other SQL statement here;",dbFailOnError
End Select

 

[missinglinq]

To quote that wise old Vancouverite, "Huh?" The intent of your code is quite clear, but your explanation of your problem still makes no absolutely sense!

Linq ;0)>