Fill Word fields using Access data

Question

I have an existing fillable form in Word that uses multiple checkboxes and text fields. The user manually checks the appropriate check boxes and types in a little bit of info in some of the text boxes.  However, one of the text boxes asks for an action level number.  Each Action Level number (over a 100 of them) has a correspondng definition that goes with it.  This information is currently held inside an Access database but could be exported to Excel if that would be easier.

My goal is to have the user be able to either, select the appropriate action level number from some kind of a list or just type it into the text box.  Once they tab or move to the next field, the corresponding definition will automatically appear in a second text box called Action Level Description.  I know that I cannot use a drop down box due to the 25 item limit.  Any suggestions?

Answer 1

See the following page of Greg Maxey's website: http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

It contains information of populating a ListBox or ComboBox from various sources, including Access