Microsoft Access - Combo Box saves key to table, not names

0
votes

Well needing a bit of help here...

Instead of explaining the entire situation, I will give an example.

Two tables. Table1 has StudentID and Name. Table2 has StudentID and Name as well. Both tables have StudentID as a key.

I have created a form which has a combo box where the combo box is meant to get the values from Table1's Name and input them into Table2's Name. Though every time I check the table after I have filled the form out, it puts the StudentID instead in the Name box into Table2's Name column. What is weird is that the form shows the drop down of names, but when selected and go to Table2, it just inputs the StudentID instead.

Any help would be thanked. Pretty bad at making situations but I was hoping the issue wasn't too much of an issue.

NOTE: This was all made with the Combo Box Wizard.

Form Form

Table1 Table1

Table2 Table2

1
ms-access

1 Answers

1
votes

Through the properties of the combobox you should set Bound Column on the Data-tab to 2 (assuming that Last Name is the second column in the Row Source of the combobox)