I have a 2 questions:

1. How do I add the following selections (Akron Cincinnati, Columbus, Dayton , Youngstown) to a Combo Box(ActiveX Control)?


2. Based on a selection in the above Combo Box(ActiveX Control of either Akron, Cincinnati, Columbus, Dayton, Youngstown. Populate five different Text Box(ActiveX control)?

For example, If I select "Akron" in the Combo Box(ActiveX Control)? The following Text Boxes(ActiveX controls) would populate. see below

Combo Box 1 = Akron
Text Box 1 = Kim Lee
Text Box 1 = 123 No Name Street
Text Box 1 = Cols, Oh 45623
Text Box 1 = 214-567-8954
Text Box 1 = klee@msn.com

Any assistance would be great.