Select Record from combo box

[AndeanWayne]

I have a form for entering property tax. The form is based on a table called investments. The form contains a combo box to select the appropriate property for data entry to the table. The two fields in the combo box are Property PIN and Property ID. The property ID is a combination of tax year+state+county+PIN. The same property can come up in more than one tax year so there are duplicate PINs but the Property ID is unique and is the key field. My problem is the combo box shows the duplicate PINs with their respective unique Property IDs as separate records but will only select the record for the earliest tax year regardless of which records I select on the combo box.

 

[RuralGuy]

What code do you have in the AfterUpdate event of the ComboBox?

 

[AndeanWayne]

Record First
Where Condition ="[PIN_Number] = " & "'" & [Screen].[ActiveControl] & "'"

 

[RuralGuy]

Is that a macro? It should be searching on the [Property ID] and not the [PIN_Number]