Check BoundTo property and set it to true.

>Bound column = 2
>Column count = 1
>Control source= name of the required
>RowSource = SQL construct
>RowSourceType = 3 (SQL Statement)
>Style = 2 (dropdown list)
>
>The problem is that the returned value should be the primary key associated with the selected field.
>
>Instead it returns the number of what I selected
>
>
>
>Example
>
>Displayed Value
>
>Name, Primary key
>==============
>
>Bob,25
>Sam,32
>
>Instead of returning 25 when I select Bob the value that goes in the table is 1.
>
>What's wrong here?