I'm tring to toggle the visible property of a column in a sub form based on input from a check box on the main unbound form
If Me.Check55 = True Then
'This part works fine, if checkbox 55 is true the subform filters records based on "DBSUB.[Austin] Yes or No
strWhere = strWhere & " AND " & "DBSUB.[Austin] = " & Me.Check55
'These are just a few of my attempts to hide other columns that are not needed
Me!DBSUB.Dallas.ColumnHidden = True
'Forms!DBSUB.Controls!Dallas.Visible = False
'Forms!DBSUB.Dallas.Visible = False
'Me!DBSUB(Dallas).Visible = False
'None of these work, please any suggestions?
End If
If Me.Check55 = True Then
'This part works fine, if checkbox 55 is true the subform filters records based on "DBSUB.[Austin] Yes or No
strWhere = strWhere & " AND " & "DBSUB.[Austin] = " & Me.Check55
'These are just a few of my attempts to hide other columns that are not needed
Me!DBSUB.Dallas.ColumnHidden = True
'Forms!DBSUB.Controls!Dallas.Visible = False
'Forms!DBSUB.Dallas.Visible = False
'Me!DBSUB(Dallas).Visible = False
'None of these work, please any suggestions?
End If