Add a User to a table

[label027]

I have a data entry form created to add a new rep to the RepList table. I have a combo box where you can select the Firm ID and a text box that pulls up the name of the Firm when the combo box selects a certain Firm ID. The Combo box and text box are both pulling information from the RepList table. I also have a few other texts boxes that are, along with the Firm ID, bound to the RepList table.

I can't seem to figure out how to bind the text box with the firm name to the RepList table. Under Control Source I have =[FirmID].[column](1) that pulls the name of the firm from the selected Firm ID.

How can I get the text box to bind to the RepList table so the new user has all fields of the table filled in correctly?

Thank you for the help and sorry, (obviously) I am quite new to this Access thing.

[June7]

Give the combobox a name different from the field it is bound to, like cbxFirmID. I do this with all bound controls. Then in the textbox ControlSource: =cbxFirmID.Column(1). Controls with an expression as ControlSource cannot be bound to field.

A principle of relational database is 'don't duplicate data'. You have a table of firms and a table of reps? Should not duplicate the firm name in the reps table, just save the FirmID.

Use queries to join tables and retrieve related data.