Checkbox wont respond at all ??

[ksor]

I have some tabs in a form and on more of these tabs I have a checkbox for setting a file reference to PRIVATE or NOT - it works well !


I got it to work on ONE tab and just copied the control and the underlaying code to the other tabs.


Today I added a new tab and has done the same copy-method of the checkbox and the underlaying code - but on this tab it will NOT work at all - no respond at all !
I CAN change the field in the underlaying query - no problems here !
In the event method for the checkbox it will NOT even stop by a breakpoint :banghead:

What am I overlooking here ?

 

[Gasman]

Is there an event selected in the property sheet for the control?

 

[arnelgp]

on Edit view of the form go to that Tab.
select the checkbox and click on the Click Event Property.
does it goes to you code? if not add the code there.

 

[ksor]

>> gasman and arnelgp


Yes, it's all there ... that's the way I inserted the breakpoint :banghead:... but it DOESN'T stop here when I click the checkbox.


(BTW: I still works on the other tabs !)

 

[Gasman]

This going to be something silly.
Back to basics.

Are in the correct form?
If you go from the Event on the Property Sheet using the ..., does that take you to the correct code ?
Put an extra line in (msgbox perhaps) just to distinguish it from all your others.?

 

[ksor]

This going to be something silly.
Back to basics.

Are in the correct form?
If you go from the Event on the Property Sheet using the ..., does that take you to the correct code ?
Put an extra line in (msgbox perhaps) just to distinguish it from all your others.?

Yesy it's back to basic methods :banghead:
... and I have tried but I'll do it again !


Merry Xmas and Happy New Year !


Now it's homeward !

 

[Gasman]

It would be nice to get to the bottom of it, but for the time it has taken, you could have created the checkbox from scratch and written the code all over again.

 

[ksor]

Yeah, I think I'll have to do that !


... and it's very frustrating NOT to find out why :banghead::banghead:

 

[ksor]

I GOT IT !


Somehow I got a setting LOCKED !


Under properties DATA-tab with



focus on the SUBFORM



I have got the setting


LOCKED = Yes


and it should be set to NO !


:banghead:

 

[Gasman]

Told you it would be something silly.

So you did not just copy it as you did the others.

Well done for persevering, I know how that feels.

Enjoy Xmas now.

 

[ksor]

Told you it would be something silly.

So you did not just copy it as you did the others.

Well done for persevering, I know how that feels.

Enjoy Xmas now.

I too was sure I was overlooking some setting somewhere ... but where !


The lesson learned here is:
Be aware of what is selected BEFORE doing any change in settings !


And I think it's completely stupid when I click a CONTROLin a subform that it "stops halfway" selecting the SUBFORM instead of the CONTROL IN THE subform ...



I have to say something to my defence


Thx for your time and Merry Xmas to you too !