Disable the update on subform if field is not..

[calvinle]

Hi,

I wonder if anyone can help me out on this.

I have a main form and 2 subform. The first subform has a field for %. And the 2nd subform has series of checkbox (Checklist or error made by the student)

Because every checkbox will lower the mark from 100 to x points per checkbox.

So, I want that, if the field is not set to 100 yet, then they will not be able to check any box in the subform.

I tried, before update of the subform, etc, but none work properly.

 

[CJ_London]

I would use conditional formatting for each checkbox to disabled if the % control is not completed, referring to the value in the % field. You haven't provided any names so assuming as described in your post then it would be something like this

Expression is...Parent.%subformname.%controlname<>100 - and set the format to disabled (the option on the right)

 

[llkhoutx]

Lock the subform on the main form Load (startup), OnCurrent (moving to a new record) and AfterUpdate (after <controlname> is updated) events based up the <controlname> value.

 

[calvinle]

I would use conditional formatting for each checkbox to disabled if the % control is not completed, referring to the value in the % field. You haven't provided any names so assuming as described in your post then it would be something like this

Expression is...Parent.%subformname.%controlname<>100 - and set the format to disabled (the option on the right)

The checkbox are from the record field. There is no conditional format for the field.

 

[CJ_London]

Sorry - forgot about that