CommandButton resets values of public variables (Word 2003)

[GarryBrooke]

I have a Word 2003 template which is a form. Users use the template to open a blank form.

The form has a number of formfields and (activex) commandbuttons. It also has two public variables, the values of which need to be available to the Click event procedures that are invoked by the commandbuttons.

However, when users click on any of the buttons, all the public variables are reset to their default values, losing the values set in other procedures.

Can anyone help me debug this ?

Thanks

Garry

[HansV]

We'll need detailed information:
- How are the public variables set, and when?
- How do the command buttons use the public variables?
- What other code do the command buttons run?

Could you attach a zipped copy of the template? You can strip out most of the contents, leave just enough to demonstrate the problem. Remove or alter sensitive/proprietary information.

[GarryBrooke]

Hello,

• The public variables are set at the module level.
• The command buttons invoke private code on the Click event. I had hoped that the public variables would be available but they're not.
• The buttons run code to add/remove additional sections to the form.

I found a solution by creating variables that are stored in the file (ie. ActiveDocument.Variables.Add). I store the values I want in those variables and get their values inside the Command button code. It's crude but it now works.

Many thanks.


Garry