title: Writing Linked Table Data to Word (from Access)
body: <p>I modified some code I saw which opens a word template and populates it by replacing bookmarks with the current record. Everything works fine until I try to write content from a linked (lookup) table, e.g.</p>
  
  <p>Table A:</p>
  
  <pre><code>ID
  Name
  Description
  JobType (lookup drop down list by JobTypeID in Table B)
  </code></pre>
  
  <p>Table B:</p>
  
  <pre><code>JobTypeID
  JobType
  </code></pre>
  
  <p>Form C:</p>
  
  <pre><code>ID
  Name
  Description
  JobType
  </code></pre>
  
  <p>This all works as planned in the form, and works for most when I click a button with:</p>
  
  <pre><code>'code for connecting to word and opening templates works fine *snip*
  
  With WordApp.Selection
      .Goto what:=wdGoToBookmark, Name:="bmName"
      .TypeText [Name]
  </code></pre>
  
  <p>But when I use:</p>
  
  <pre><code>With WordApp.Selection
      .Goto what:=wdGoToBookmark, Name:="bmJobType"
      .TypeText [JobType]
  </code></pre>
  
  <p>it doesn't write the job type thats stored in the table or displayed in the drop down box on the form.... it writes the JobTypeID (1,2,3,4....) used in the link.</p>
  
  <p>Ive also tried using
       me.JobTypeComboBox.value
  from the form, but this also displays the ID.
  Can someone point me in the right direction please.</p>