Populate table with input from Form with Combo Box (multiple fields)

[tonere]

Hello All,

I am using Access 2007 and have reviewed many blogs and looked at the Northwind db to try to solve this problem. I would like to create a form that functions in the same manner as the "Order Details" form in the Northwind db. Specifically, I want to create a form that will allow me to input a value and have the form get data from another table and populate the table I need populated.

I would like to populate a table "Outside", field names are Key, Name, term, Value, Date.



The table that contains the data is named "CV" and the filed names are Key, Name.

In the form, I would like to enter a value for Key into a combo box, and have it put the value for Key and for Name into the form, and allow me to enter whatever I want to in the Term, Value and Date field. When I tab out, I would like all this data to be in the table "Outside.

Thank you for your help in advance.

[alansidman]

Go to this web site. Scroll down to the three tutorials on combo boxes.

http://www.datapigtechnologies.com/AccessMain.htm

Alan

[tonere]

Thank you Alan, I had already viewed all three of those tutorials. They were excellent tutorials but did not get me where I want to be. (The second tutorial actually gave me an idea that I will probably use in another form.) I still cannot get my form to automatically populate multiple fields. I do not get how (in the Northwinds DB) you can input the customer name in a combo box and have all the contact data automatically populated and stored in another table.

[JennyHunt]

I have the same issue. Did you find a resolution?
Thanks

[tonere]

I have not found the soultion YET. I have read posts in other Access forums until my eyes hurt but cannot find a definitive answer.

[JennyHunt]

Wow. Well I will certainly let you know if I find an answer.

[mcguires99]

I have not found the soultion YET. I have read posts in other Access forums until my eyes hurt but cannot find a definitive answer.

Have you had any success with this yet??

[tonere]

I have not found the solution. Do you have anything?

[mcguires99]

Sorry nothing yet tried a few weeks back but being a real novice only received replies I didnt understand. If I get anything will post.