Afterupdate() hide a column on subform

[Delid4ve]

I have a case statement to show hide fields as applicable.

I need to hide/show a couple of fields in the subform based on the main form selection but cannot work out how i have to reference this in my statement.
Mani Form = Record
Subform = Record_Cylinders
Field to hide = QtyUsedRecovered

This is part of my case statement for the main form:
Private Sub DocumentType_AfterUpdate()
Select Case Me.DocumentType.Value
Case "Collection Note"
Me.Combo31.Visible = True
Me.Combo33.Visible = True
Me.CollectionDate.Visible = True
Me.Combo41.Visible = True
Me.Combo35.Visible = False
Me.Combo37.Visible = False
Me.Combo43.Visible = False
Me.Combo39.Visible = False
Me.ReturnDate.Visible = False
Me.DisposalType.Visible = False
Me.QtyDisposed.Visible = False

 

[leanpilar]

depend where you are, in main form, module or subform...
forms!mainform.subform.form.fieldtohide.visible = false is the long version

 

[Delid4ve]

Thanks

By long version I assume you mean that this works anywhere.

 

[leanpilar]

Yes anywhere I know. Even in itemediate window

 

[CJ_London]

if your subform is a datasheet, then visible won't work - you need to set the columnwidth to 0 or columnhidden to true