Saving of hidden columns

[Guest]

Access 2000

I have a form with a subform. certain columns on the subform are hidden. I
want the user to be able to hide/unhide columns and that selection be saved
when the user opens the application the next time. This works with a MDB but
not with a MDE. Are there other methods that will allow saving of individual
user column hidden/unhidden choices. Thes choices would change from time to
time.

Thanks

 

[George Nicholson]

One possible approach:

Create a "UserSettings" table and create records for "Form1Settings",
"Form2Settings", etc. when the user closes the form. Programatically restore
those settings when the form is opened.


HTH,