Searching with Combo Box

[gear]

In my Access DB, I have a field named ‘REFNO’. This contains reference numbers of some communications. I have a Combo Box to search records with this ‘REFNO.’ It so happened that there were two communications with the same REFNO. When I typed the wanted number in the Combo Box, only one record was displayed in the form which was not the one I wanted. I was able to see the other record by opening the table. Is there a way to display the next record with the same number in the form with the Combo Box? Grateful for help.

 

[neileg]

Build a query that extracts all the REFNOs and base your combo on that. Build another query that uses the combo box as a criterion to select the records that match the REFNO in the combo and base the display in the form on the second query.