Combo saving row # not field

[arage]

Combo saving row # not field
My bound combo box accurately provides a filtered list of choices to choose from but the value stored in the field bound to the combo control is the row number of the filtered list provided by the combo control.

My combo control ought to be storing a retailer number instead of the row number of a record.

 

[arage]

Yes I’m sure its not storing the primary key because when I check the record source behind my form, I can see that the row # of the filtered list is being saved. I put 0 (the list index as the bound property) it should have been 1, problem solved thanks!