Unlock a form for further editing withou losing the input data

[tammytutone]

I have a new form template that I want to unlock after the data in the form fields has been entered. I put a macro in the last field to trigger the unlocking of the form, but once the form is unlocked, the data that the user entered disappears. How can I unlock the form and keep the data which was entered? I have attached the form. To see it work, press tab after making a selection in the very last form field.

[Chukesgirl]

I am having the same issue with a Word 2007 form. What version of Word are you using?

[fumei]

Yes. I tab out of the last formfield, and all data entered prior to that last one remains. It is not cleared.

If you use the menu to protect it again, yes THAT will clear the data.

Unless you do NOT use the menu, and use code as macropod gave, with NoReset:=True.

[fumei]

BTW: that is not a form template.