Populate dropdown list with data from Access table

[spw4000]

I have a document that includes text fields that I want to be automatically completed based on a selection from a dropdown list. The list is to show values from one field in a table in an access database (eg. job name) and, when selected, will complete fields in the document with data from that record in the table.



The number of records in the table is already over 25 and will only increase, so a userform is required. This much I know. I really need helping listing the 'job names' for selection from the access table and then inserting relevant data into my document based on this.

All pointers or code snippets MUCH appreciated.