Hi,

I have designed a UserForm which is used to add new members but this form would be used to edit and delete them as well. So instead of creating another identical UserForm, I would like to use this one.

Problems
  1. I have at the moment code that places todays date in a text box automatically but it is editable if a member joined before the date they enter it onto the system.

    This would need to be disabled, so that when viewing a members details the date joined would not be overriden.
  2. The caption on the form would change, and an extra button 'Delete' should appear.

Is it possible to set a variable or something so if variable = add then this if not then this.