In the code below I am trying to lookup a part number by a partial match (ex: find CH PS-1 by searching for PS). If I change LIKE to = and remove the wildcards I can successfully search for the entire part number. Can anyone see my error?
Code:Private Sub btnPartLookup_Click() Dim myF As Form Set myF = Forms("frmNav") DoCmd.OpenForm "frmPartList", acNormal, , "[PARTNO] LIKE '%" & myF!txtCatNum & "%'" Set myF = Nothing End Sub