[Access] Dependent Control Source

I've created a contacts database, and I have a form where the user can add a new company. On the form, I have a combo box that lists the company types and then a text box where you enter the new company name. Is there a way to have the control source of the company text box be dependent upon the selection in the combo box? I want the name of the company to be saved in a table with the same name as the company type selected in the combo box. Thanks.

a sql statement with an inner join should accomplish this, you might want to read the tutorial on ado