I have a form that fires some code when it closes. The code hides columns in a subform (datasheet view). The code works fine, but the columns in the subform do not stay hidden the next time the form (with the subform) is opened.
I presume I need to amend my code to save the subform after the columns have been hidden, but I don't know the syntax. I'm familiar with VBA for Office programs, but not for Access (2000).
Grateful for any help.