I chose to us "on change" instead of "on click".
Code:
Private Sub qrep1_Change()
DoCmd.OpenQuery "Rep Filter", acViewNormal
End Sub
I changed the Query Criteria to:
Code:
Like [Forms]![SEARCH].[REP] & "*"
If I understand what you are saying, your combo box has two records in it. Jeff and Paul.
Yes.
I can't figure out why the combo box is populating with 3 values of "Paul" in Form View. Also, the 4th picture on the right, how do Ihow do I get the query to run on the SEARCH from and not open the query.
Alan,
I really appreciate the help more than you know!
Once I figure out how this works a bit more I will not be so needy