Why On Click event of a checkbox doesn't respond?

[The_Doc_Man]

I'm going to speculate here. It is possible to cancel a double-click because there is a Cancel parameter in the call sequence. We can't see a cancel option for the single-click - but Access can. I looked it up and there is no comment on it, but I'll bet that when Access goes to implement the click that would normally update the button, it finds that it can't so does a Cancel that we can't get to - because it has to cancel the update. Understand, this is all speculation.

@Tera, can you just unbind the checkbox and get THAT to click? You couldn't update your original underlying query because it was not updatable, so it seems that it shouldn't matter whether the checkbox was or wasn't checked originally - you aren't going to change it. I would think that you ought to be able field a click on an unbound control. I know I have used a double-click on a label as a "backdoor" trigger to start a sequence that, if I did the right things in the right order, would unlock a locked DB. According to the MS documentation site, a single-click is legal on a label, and that would be just as unchangeable as bound control that can't be updated due to the underlying recordsource.

 

[deletedT]

can you just unbind the checkbox and get THAT to click?

Yes, If the checkbox is unbind, the on_Click action triggers the function.

Since the record source is read only, I'm not able to update the records. Anyhow I need to be able to update that checkbox.
Well if I can not update the field, I tried to use a function that is fired when I click the checkbox. The function will update the corresponding table and refresh (requery) the form.

 

[arnelgp]

it was an old trick, you know

 

[Minty]

The explanation is I think quite simple, uniquely in a checkbox the click event would normally change the data, when the underlying data is uneditable that cannot be achieved so the click event is ignored.