Non/Editable SubForm Based On Checkbox From Main Form.

[MagnusFox]

Main Form based on a query that returns a pair of Yes/No fields with the default value of Yes. Therefore the Main Form creates a new record with two checkboxes that are checked.

I want the sub form to remain locked/non-editable until all checkboxes are cleared (value No). Once the subform sees that all checkboxes are not Yes, unlock the subform so the user can enter data on the subform.

How, What and Where do I place code to achieve this?

Many Thanks

 

[JoeMiller]

In the after update event of each checkbox you can put this code to decide if the subform can be enabled:

[tt]
If MyCheckBox1 = 0 And MyCheckBox2 = 0 then
Me.SubFormName.Enabled = True
Else
Me.SubFormName.Enabled = False
End If
[/tt]

HTH
Joe Miller
joe.miller@flotech.net