'In this example, by double clicking on a specific field, in this case YR, it sets the form focus to YR, brings up the search bar and after entering your criteria in searches in the YR field ONLY for that value     


Private Sub Yr_DblClick(Cancel As Integer)

    

    Yr.SetFocus

    DoCmd.RunCommand acCmdFind

    

End Sub