Combobox via Select Case

Hello everyone. I have a userform in an excel spreadsheet that has two combo boxes on it (for now, more stuff willl be added). In the first combo box, the user may select from two options: Customer or Terminal. (I have that part up-and-running). For the second combobox what needs to get done is trickier.

Depending on what the user selects I need the following to occur:

1. If the user selects "Customer", then the second combo box will contain a list of Customers. That list is in an Access databse table called Customers.

2. If the user selects "Terminal", then the second combobox will contain a list of terminals. That list is in an Access databse table called Terminals.

I am using this Private sub to create the database connection:

Please Login or Register  to view this content.

The userform is launched via:

Please Login or Register  to view this content.

Any help is greatly appreciated. I am developing using Access and Excel 97.