Forms-Drop Down Lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am rtrying to make a quotation form, I want the ability to develop drop down lists and not only use it multiple times within the quotation but also use the same list in other quotation forms. It appears to me that you have to renter the drop down items every time you want to reuse the same list i tried naming it in the "Bookmark" field but apparantly that does not work. Example of what I am trying to do: I want a drop down list called "Bushings" that consists of 3 choices; iron, carbon, or brass. I might use the Bushing list 3 times in this quote form and then again in another, new quote form. Do I have to re-enter the items everytime I want to add a drop down field

thanks for the help
 
Terry,

Will the data selected be the same in all three places? I mean if you
choose "Brass" in the first drop down will the choice in the other locations
also be brass? If so, use REF fields in the two succeeding locations rather
than more drop down fields.

By default the first dropdown field in a form is bookmarked Dropdown1. If
you want the results to appear in other locations you can use { REF
Dropdown1 } where the { } is inserted with CTRL+F9. After entering the
field, presss ALT+F to toggle the code. In you dropdown1 field check
"calculate on exit."

If the choices need to be different, you and copy and paste as many
additional dropdown fields as you want.

HTH
 
Thanks for the reply Greg, yes the choice could be different but that choice would always be contained within that list of 3 items. I tried to cut & paste but was unable to do so, I guess i must be missing something. I tried to research this on MS Office help but could not find any related info
 
Plan B

Insert the dropdown field from the forms toolbar.
Enter your three choices and OK out of the dialog.
Select the field and press ALT+F3 (Autotext)
Save with a suitable name eg Dropdown.
Insert the autotext entry wherever you want this field type.
The only proviso is that each new field will have the dropdown1 bookmark
name - the existing similar ones will jave no bookmark name. If you want to
cross reference the fields in the document as suggested by Greg, you will
have to name them.

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

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><
 
Back
Top