I'm trying to create a split form. I have created a checkbox in the header of the form that will hide/unhide a set of columns in the datasheet portion of the form. The code I am using to do so look like this:
Private Sub chkAddress_AfterUpdate()
Dim ctrl As Control
For Each ctrl In Me
If ctrl.Tag = "Address" Then ctrl.ColumnHidden = Not chkAddress
Next ctrl
End Sub
The code works executes properly but the columns don't get hidden. They remain visible, but I can not select a cell in them.
I'm hoping that there is a method that I need to call to make the datasheet part of the from refresh/update to actually remove the columns.