VB Code:
'Assumes you have a table with fields ID and Name,
'and have filled a dataset with those records,
'and bound cboMyCombo to the correct table
With cboMyCombo
.DisplayMember = "Name" 'this is what user sees in combobox
.ValueMember = "ID" 'this is what's returned when user selects a name
End with
.
.
.
'User clicks a choice
cboMyCombo_SelectedIndexChanged( ByVal .....) 'event handler
dim lngID As Long 'assumes ID fiels is a Long value - change if needed.
'Long is default for Access autonumber
lng ID = cboMyCombo.SelectedValue 'returns ID
'do what you want with this value
End Sub