Disabling a subform

[UT227]

I have a subform that I'm trying to disable. When I click on a check, I want it to enable and disable when it's not clicked. Here's the code:
Private Sub ContrabandFound_Click()
If (ContrabandFound) Then
Me.ContrabandDescr.Enabled = True
Me.frmContrabandTypeSubF.Enabled = True
Else
Me.ContrabandDescr.Enabled = False
Me.frmContrabandTypeSubF.Enabled = False
End If



End Sub

The subform (frmContrabandTypeSubF) will not disable. The code works fine for the field (ContrabandDescr). How can I disable that subform when the check mark is not checked?

[June7]

What is name of the subform container control that holds the form? Reference the container control. I always name container different from object it holds, like: ctrDetails.
If container and form have same name, your code should work. Visually, the subform will appear same but should not be able to edit data when disabled.

Code can be simplified:

Private Sub ContrabandFound_Click()
        Me.ContrabandDescr.Enabled = Me.ContrabandFound
        Me.ctrDetails.Enabled = Me.ContrabandFound
End Sub

The code is not working for a field, code is setting properties of controls.
If ContrabandDescr is a textbox or combobox, can use Conditional Formatting instead of VBA.
I also usually name controls different from field, such as tbxContraband.

[UT227]

What is a container control?

[June7]

A subform or subreport is created by placing a subform/subreport container control on form or report. The container holds a table/query/form/report as defined in SourceObject property. https://support.office.com/en-us/art...esubformwizard

[UT227]

I understand the subform. I'm just not understanding what the container control is. I can't find that in the property of the subform.

[June7]

You won't. It's not a property. As described in linked tutorial, it is a control that can be selected from the Design tab. The container control has a SourceObject property. This is were you indicate what object (table/query/form/report) the container should hold.

[UT227]

The subform is called [frmContrabandTypeSubF]
Master Field: PublicContactID
Child Field: PublicContactID
It's getting information from table: [tblContrabandType]

Does that help?

[June7]

Sounds like the container and the form it holds have the same name. But you do not show content of the SourceObject property so only a guess.

Probably should also have code in form Current event.

If you want to provide db for analysis, follow instructions at bottom of my post.

[UT227]

I put it in the for Current event. Here's the code:


If (SearchConducted) Then
Me.cboReasonForSearch.Enabled = True
Else
Me.cboReasonForSearch.Enabled = False
End If

If (ContrabandFound) Then
Me.ContrabandDescr.Enabled = True
Me.frmContrabandTypeSubF.Enabled = True
Else
Me.ContrabandDescr.Enabled = False
Me.frmContrabandTypeSubF.Enabled = False
End If

If (ArrestMade) Then
Me.cboReasonForArrest.Enabled = True
Else
Me.cboReasonForArrest.Enabled = False
End If

It works for the fields on the form, but not for the subform.

[UT227]

I figured it out. The code does work. I have some other code in the Current event. That code contradicted this one. I put it at the end of the code and it works perfectly. Thanks for the time.