Selecting Record from Combo Box.

[AndeanWayne]

I have a form to modify existing property records. Each record has a PIN number and a unique ID which is a combination of year, state county and PIN. The same property can have a record for more than one year. On this form I have a combo box for selecting the record to be modified. The combo box includes PIN and Prop ID. The combo displays each record by PIN then ID as separate records. For example:
PIN Prop ID
06104409012 2007-IL-Lake-06104409012
06104409012 2010-IL-Lake-06104409012
But when I select a record it will always select the first record with identical PINs. In the case above if I click the 2010 ID the record fills in with the 2007 ID.
Help!

 

[pbaldy]

You need to be using the unique ID to find a record, not the pin.

 

[AndeanWayne]

The users are familiar with the PIN. The same property can appear in subsequent years. The combo shows the PIN and the PropIDs (unique ID) for each PIN as separate records. They also show as separate records in the table and query. But, the combo box will only select one of the records (1010 for example) regardless of which record is clicked.

 

[pbaldy]

If your code uses PIN, how is Access to know which one you want? You have to use the unique ID in your code, so it's looking for 2010-IL-Lake-06104409012, not 06104409012.