Populaing only the Key field value form a combo box selection

[Tskutnik]

In the Contacts Table there are two fields, the unique Contact ID key field numeric and the Contact Name. Like this:
Contact_ID; Name
1; Tom
2; Dick
3; Harry

In a form named “Selection” there is a Combo box that references the Contact table, and lists just the three names in the drop down (showing the Contact_ID is optional - I'm fine either way):
Tom
Dick
Harry

When the selection is made it will populate the field Contact_Ref the table called SelectedName.

Question: When the user selects the name I’d like the data populated in the SelectedName table to be the Contact_ID Value, and not the Name, so if Harry is selected the Value “3” would be saved.

I’m sure this is easy – but I’m new…

Any help is appreciated.

 

[pbaldy]

The bound column property of the combo determines which field is saved.

 

[Tskutnik]

Thanks for the help.

Issue closed

 

[pbaldy]

No problem.