How do I dynamically populate the fields in a userform?

I have a userform in a template in Word 2010 which asks the operator to enter details about a document., e.g. name, date, reference number and the like. These field labels are in English. I want to convert this userform so that it gives the same details but in French. I know I could duplicate the userform and have one in English and one in French and have them displayed using the appropriate VBA.
However, I would like to go down the path of having one userform and populating it from an Access table depending on the language required. I want to use DAO to connect to the database.
Can this be done, please? And how might I go about it?