How to make a drop down list in Word 2016 using an Acces database? RRS feed

  • Question

  • I have lots of word-documents (Word 2016) that I shared with my team. Each member can individualize his documents by assigning himself as a point of contact in the document text, using a drop down list.

    Each time a new member arrivés at my team, or when someone leaves, I have to adjust the drop down lists in each separate document, which is quite time-consuming.

    Therefore I made a unique Acces database containing all teammembers.

    How can I refer to this unique database in my drop down list to ensure that each database modification affects each drop down list?

    Friday, August 17, 2018 3:02 PM

All replies

  • Please describe how you inserted the dropdown list.

    Word has more than one dropdown list (there are at least three) and the code for working with them varies.

    Is the Access database a mdb or accdb file type? What's the table name and the field name that should provide the source? (Or the query name and field name)

    I assume the list should populate when the document is opened?

    Cindy Meister, Office Developer/Word MVP, <a href=""> my blog</a>

    Sunday, August 19, 2018 11:08 AM