Hi,
I've got a form/dialog box that allows users to select a person's name from a list control. I let the user sort the list in ascending OR descending order by a command button.

I change the CAPTION of the command button (when the user clicks on it) to indicate which order the list is sorted. I'D LIKE TO SAVE THE FORM WITH THESE CHANGES, however when the form closes and then later opens again the form is "reset" back to its original state (the CAPTION changes are lost).

When the form is closed, I use the acSaveYes option (which I thought would be my answer) but this does not have the desired effect.

Any thoughts would be appreciated. My work-around has been to put the CAPTION changes into a hidden txtbox and recreate the CAPTION upon a Form_Open subroutine. Unfortunately, the form has approximately 10 customizable aspects like the CAPTION example above and I'm having to "recreate" the look of the form through hidden txtboxes everytime the form is opened.

Thanks for any help,
Jeff

If the users are sharing the same copy of the frontend database, each user change would override the previous. You're better off storing the customizable values in a table keyed by userID and then applying them when the form is opened.