Like Operator not Working in OpenForm Command

[bcournoyer]

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?

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

[bcournoyer]

Solved my own post. Exchanged * wildcards for % wildcards and it worked.

[Minty]

% wildcards are the SQL-ANSI standards, * are Access and Excel.

You can make Access use the ANSI version if you tick the appropriate box in the File¬ Options ¬ Object Designers section.