Select Record from combo box

[AndeanWayne]

I have a form based on a table with a combo box to select a record. The fields in the combo box are PIN (a ten digit number to identify a property: example 0208101010) and PropID (a field identifier made up of the tax year, state, county and PIN - example: 2008-IL-Lake-0208101010). PINs can have duplicates (same property but different years) but the PropID is unique. My combo box displays both fields perfectly with PINs in ascending order. The problem is that is there are multiple PINs for different year such as 2008, 2010 and 2011 a;ll records display on the combo box but will only display the latest year PropID on the form regardless of which of the three are selected. How can I display the PINs in order and select the appropriate PropID when PINs are the same?