By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,308 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

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

P: 2
We have two tables in that control some different data. Table one is dbo_ProductModel. Table two is dbo_CustomerInformation. Table three is dbo_WebInformation. I created the form from the dbo_WebInformation 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:
Expand|Select|Wrap|Line Numbers
  1. 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_WebInformation 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?
May 3 '10 #1
Share this Question
Share on Google+
1 Reply

P: 2
Forgot to mention that I'm on Access 2007 and Windows XP sp3
May 3 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.