How to let the user click an unbound checkbox

[waldemar]

I have a continous form with several checkboxes, each of them has a "formula", that returns True or False: ControlSource=myFunction('blabla')

Now the user is not able to EDIT this checkbox anymore... it seems to be kind of 'locked'... Does anybody have an idea/approach to this problem? I need to keep the formula (can't put it in the oncurrent-event, since this is a continous form) AND let the user click on the checkboxes...

 

[chrissie1]

click in design on your checkbox and the go to the menu format and click conditinal formating try to set you condition here, i think you can even set in a function "What a wonderfull world" - Louis armstrong

 

[waldemar]

I selected the checkbox and looked in the Format menu, but... "Conditional Format" is disabled!...

 

[shannonp]

Irregardless of your form being continuous, I'm pretty sure you should still be able to set your formula into the oncurrent event.

What happens when you do this?

 

[waldemar]

When I put the code into the form's oncurrent event, it will be only executed ONE time (for the first recordset).
When I click on one the checkboxes ALL record's checkboxes are affected (hey wait a second, there is something really wrong here; this means I can not edit the record at all?? Sound like there is something wrong with the query...?!?)

 

[chrissie1]

no this is completly normal, in a continous form and the only way to do what you want is with the conditional formatting try it a bit more "What a wonderfull world" - Louis armstrong

 

[Honestmath]

hey,

i think this will also happen if the form is set to
allowedits=false.

happened to me a few times.

best,

Math

 

[waldemar]

I guess Conditional format doesnt help me here, since these checkboxes are *unbound*. I am using the values of these checkboxes to influence another variable (an integer) which is saved in the record. So *that* sounds like I can't get around putting the function call in the controlsource property (so it will be executed for each record), but now they can't be clicked anymore..... Aarrrrggkllllll