How to make a checkbox hide a field in subform on a tab control

[neelsfer]

I have been struggling for 4 hours now with this. When i click the checkbox, it is suppose to hide a specific field [NPItemtype] in a subform [NPCaptOtherSF] which is situated on a tab control with other subforms
(columns = option group for checkbox)
i have tried the following:

If Forms![fis_npcaptureF]![Columns] = 1 Then [Forms]![fis_npcaptureF]![NPCaptOtherSF]![NPItemtype].ColumnHidden = True
else
[Forms]![fis_npcaptureF]![NPCaptOtherSF]![NPItemtype].ColumnHidden = False
 

also tried

If Forms![fis_npcaptureF]![Columns] = 1 Then [Forms]![fis_npcaptureF]![NPCaptOtherSF]![NPItemtype].visible = false
else
[Forms]![fis_npcaptureF]![NPCaptOtherSF]![NPItemtype].visible = True

I am not sure whether it is the Tab control affecting it.
Please be so kind to assist.

[NeoPa]

To start with, all references should be relative to the Me reference.

For the basic information from which you should be able to determine this for yourself, see Referring to Items on a Sub-Form.

I'll assume, from what's in your question, that the following is an accurate description of what you're working with :

• Name of main form = [fis_npcaptureF].
• Name of CheckBox control = UNKNOWN. I will refer to it for now as [chkVis].
• Name of option group in which [chkVis] seems to have a value of 1 = [columns].
• Name of Tab (or Page) control = UNKNOWN. Also irrelevant so I will not refer to it at all.
• Name of the subform control on the Tab (or Page) = [NPCaptOtherSF].
• Name of control on the form, within the subform control, that you intend to show/hide = [NPItemtype].

Unfortunately, I have no info as to whether or not anything is bound, so I will assume for now that it is. An unbound form would not require a Form_Current() event procedure.

Private Sub Form_Current()
    Call ShowHide()
End Sub
 
Private Sub columns_AfterUpdate()
    Call ShowHide()
End Sub
 
Private Sub ShowHide()
    With Me
        .NPCaptOtherSF!NPItemtype.Visible = Not .chkVis
    End With
End Sum