I am creating a Word template with a userform.  The form features a combo box
populated with 175 manufacturers (using .AddItem).  When a manufacturer is
selected, I would like text boxes elsewhere in the userform (for Contact
Name, Address, Phone) to update with the chosen manufacturer's information.  
This gives the user a chance to verify this information before clicking OK
and feeding it into various areas of the document.

Rather than writing 175 Select Case statements to populate the text boxes,
I'm thinking that since I already have the contact info in an Access db
called CompanyInfo in a table called Contacts, I could somehow use this table
to feed the text boxes.  My problem is I don't know the code needed to call
the table and have it populate the text boxes.  How do I do this?  Thanks!