Move Stored Form Field Variable

[robo]

Hello,

I have dabbled in VBA (excel and access) but I'm new to Word.

I have a MS Form where a user selects from a drop down list an option. I
would like to take that option and have it appear automatically somewhere
else.

I created this to store the value of the dropdown list and told the form
field to run this on ENTRY.

Public Sub MoveOption3()

Dim Option3Data As String
Option3Data = DropDown3

End Sub

Is this right?

How would I create another text field and move that data into it?

Thanks

 

[Doug Robbins - Word MVP]

For a protected document that uses formfields, you can use a cross reference
field that uses the text of the bookmark assigned to the drop down
formfield. Set the calculate on exit property for the drop down so that
cross reference field is automatically updated.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[robo]

Thanks for your help. I tried the cross-ref field but It didn't work. Maybe
I wasn't clear.

I have a drop down list built in a protected form. ie (MR, MRS, etc)

I would like the selection that the user makes (ie MR) to also appear in
another part of the form automatically. I originally posted the idea of a
MACRO but I'm not sure the best way to approach this.

Thanks
Rob

 

[robo]

Hi Doug,

I'm sorry but you were right. I'm confused on something. It only updates
when the user TABS out of the dropdown box. If they pick up the mouse and
move away it won't work.

Is this correct?

Thanks again for your help
Rob

 

[Graham Mayor]

If the cross reference field didn't work it is because it is either in the
header/footer view, or you did not check the 'calculate on exit' property of
the form field you are cross referencing.
If it is in the header/footer view you will need a macro run on exit from
the form field to update it - see http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Graham Mayor]

Correct - that's the way protected forms work.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>