multi listbox selections to table

[bigmac59]

hello all , can you help this newbie please, I have a form with a subform, it has a list box which contains all the fields n the sub form, on selection on the list box the field in the subform disappears , so the user can select what fields are shown, BUT what I want is to be able to close and when the user re opens the form that it still only shows the fields that was shown before it closed . can you help please

[rpeare]

You'd have to save the selected fields to a table and requery the subform with those selected items when the form is reopened.