L
Lenny
I have Word 2003 protected form template consisting of a table with 5 rows
and 5 columns. Each of the 25 cells represented in the table has 2 fields...
a dropdown field and a bookmarked field to hold the value of a module
containing SelectCase. At the bottom of the form are cells for each of the 5
columns that Total the 5 values above.
The form is blank until the user makes a selection from the a dropdown (1,
2, 3, 4, 5) in any of the cells. Once selected, depending on the number
selected, the user then moves out of the cell (tab or clicks on anyther
dropdown) an On Exit macro fires the code to add the value to the bookmarked
field.
I want the user to be able to 'clear' the form... reset the dropdowns, the
fields with the SelectCase results, and the totals. Currently... The first
item in the dropdown is actually a 'space'. This is so the field appears
'blank' until one of the values in the dropdown is selected, thus, setting
off the chain of events.
The form works, correctly displaying the contents of the dropdown and the
corresponding value. It is adding the values correctly in the Total cell at
the bottom.
The problem..... when the dropdowns are cleared, which actually means just
selecting the top item in the dropdown, the 'space', the value fields will
not clear, regardless of whether I tab out of the field or do a print
preview. If I unprotect the form, do a 'select all' and press ALT F9 they
still do not clear.
Is there a way to assign the 'space' in the dropdown a null value in the
SelectCase so nothing is added to the bookmarked field, thus resulting in
null values in the other calculations. I don't want any values to show on
the form, in case the user needs to copy the form to fill in by hand.
I'm close.... but still so far
Can someone point me in the right direction? Help is always greatly
appreciated.
Lenny
and 5 columns. Each of the 25 cells represented in the table has 2 fields...
a dropdown field and a bookmarked field to hold the value of a module
containing SelectCase. At the bottom of the form are cells for each of the 5
columns that Total the 5 values above.
The form is blank until the user makes a selection from the a dropdown (1,
2, 3, 4, 5) in any of the cells. Once selected, depending on the number
selected, the user then moves out of the cell (tab or clicks on anyther
dropdown) an On Exit macro fires the code to add the value to the bookmarked
field.
I want the user to be able to 'clear' the form... reset the dropdowns, the
fields with the SelectCase results, and the totals. Currently... The first
item in the dropdown is actually a 'space'. This is so the field appears
'blank' until one of the values in the dropdown is selected, thus, setting
off the chain of events.
The form works, correctly displaying the contents of the dropdown and the
corresponding value. It is adding the values correctly in the Total cell at
the bottom.
The problem..... when the dropdowns are cleared, which actually means just
selecting the top item in the dropdown, the 'space', the value fields will
not clear, regardless of whether I tab out of the field or do a print
preview. If I unprotect the form, do a 'select all' and press ALT F9 they
still do not clear.
Is there a way to assign the 'space' in the dropdown a null value in the
SelectCase so nothing is added to the bookmarked field, thus resulting in
null values in the other calculations. I don't want any values to show on
the form, in case the user needs to copy the form to fill in by hand.
I'm close.... but still so far
Can someone point me in the right direction? Help is always greatly
appreciated.
Lenny