I currently have a few combo boxes that autofill data into text boxes. Lets say I have cmbName (combo box Name) pulling the name, department and extension of a person. The Dept and extension are placed automatically in the right text boxes using [column](x)in the CONTROL SOURCE field...OK...now, HOW do I get this data into a new TABLE since my CONTROL SOURCE field is in use by an expression?

Use column(x) etc to place the data in a subform which has an appropriate recordsource, or alternatively, add records to a table recordset using DAO code.

You don't need to save this data in two places. You can always retrieve it when you need it by adding the source table with a join in your queries.

Look up the following article in the Microsoft knowledge base for an explaination of proper table design:

Q100139 - ACC Database Normalization Basics

at: http://support.microsoft.com/support/c.asp?FR=0