Append to table from form that gets data from a different table through combo box

[btoussaint]

We have two tables in that control some different data. Table one is dbo_ProductMode l. Table two is dbo_CustomerInf ormation. Table three is dbo_WebInformat ion. I created the form from the dbo_WebInformat ion database. I have the form pull up the information for the product based on model name and the information for the customer based on customer name, both through combo boxes. The combo box for product model is controlled by the following command in RowSource:

SELECT DISTINCTROW dbo_ProductModel.Model, dbo_ProductModel.ModelName, dbo_ProductModel.Weight, dbo_ProductModel.Height, dbo_ProductModel.Depth FROM dbo_ProductModel ORDER BY dbo_ProductModel.Model;

. I then point the rest of the fields on the form to the combo box. I do this for the customer information also. I then add an amount to the form. When I go back to the dbo_WebInformat ion database, I get the amount, Model and Customer fields filled out, but not any of the other fields like the one for Name, Weight, Height, etc.

How do I get the information from the form to the table?

[btoussaint]

Forgot to mention that I'm on Access 2007 and Windows XP sp3