 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / August 2007Move Stored Form Field Variable
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 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.  SignatureHope 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 > Hello, > [quoted text clipped - 19 lines] > > Thanks 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 > 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 [quoted text clipped - 24 lines] > > > > Thanks 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 Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Thanks for your help. I tried the cross-ref field but It didn't work. > Maybe I wasn't clear. [quoted text clipped - 44 lines] >>> >>> Thanks 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 > 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 [quoted text clipped - 24 lines] > > > > Thanks Correct - that's the way protected forms work. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi Doug, > [quoted text clipped - 43 lines] >>> >>> Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.