Access 2010 Beginner 8

Access 2010 Beginner 8
By Richard Rost

10 years ago

Back to Access 2010 Beginner 8

I have a test database and I am doing a combo box Upload Images Link
Victor Solano
7 years ago

I have a test database and I am doing a combo box to pull the information from another table but the information is recording the result under the incorrect field name even though I select the correct storage field. In other word I have claimerName and claimerNo where claimerNo is the primary key from the table that I want to pull the information from. Any though

Reply from Alex Hedley:

SO [claimerNo] and [claimerName] are fields from a Table (let's call it ClaimerT).
You've created a combo box which contains both those Fields. I take it [claimerNo] is hidden and that's the value you want storing in your other Table as a Foreign Key.

What is the Table/Query (RecordSource) of the Form you have this Combo box on?
What is the Field name in this other Table that you are wanting to store the Claimer Info in?

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access 2010 Beginner 8