I have a form that calls a subform

[Zorro1265]

I have a form that calls a subform with a second subform inside it. The 2nd subform is in datasheet view. I want to hide columns depending on the setting of a combobox on the first subform. I can get the fields hidden but they wont unhide when the combobox value changes. Any ideas?

'If Forms![StressInterp]![subfrmStressData]![stress_protocol] <> 5 Then
'Me.MPH.ColumnHidden = False
'End If
'If Me.stress_protocol <> &quot;5&quot; Then
'Me.MPH.ColumnHidden = False
'Me.Grade.ColumnHidden = False
'Me.Mets.ColumnHidden = False
'End If
'If Me.stress_protocol = &quot;5&quot; Then
'Me.MPH.ColumnHidden = True
'Me.Grade.ColumnHidden = True
'Me.Mets.ColumnHidden = True
'Me.Minutes.ColumnWidth = 2880
'End If

 

[ghubbell]

I do not have a lot of experience with datasheet views as I just don't like the look of them and typically build continuous forms instead, but I will offer that you set the columnwidth property to 0 instead of trying to hide the column. The reaction is I believe what you want however the only drawback is that a savvy user can pull the column back &quot;open&quot; if they chose. Anyone? Anyone?

 

[Zorro1265]

ghubbell,

I have tried that one too. As with the other setting it will make the columns hidden all the time, not based on my combobox. I am perplexed.

 

[JerryDennison]

For all controls that are part of a subform(or subsubform) you must use the &quot;fullpath&quot; to the control:

Forms!MainFormname!SubFormName!SubSubFormName!ControlName