Open Form where number LIKE input value
<p>Basically, I need to be able to pull up a list of all parts in a certain category type based on a textbox input. I currently have a form list of all <code>Catalog</code> numbers named "_NextPartSearch". For example, take Catalog number <code>EDF50-00159</code>, where EDF50 is the category type and 00159 is the number itself.</p>

<p>With my textbox (called "NextPartValue"), I want to be able to type in EDF50 and have ALL of the part numbers show up (EDF50-00000 through EDF50-99999).</p>

<p>My code thus far is as follows:</p>

<pre><code>Private Sub NextPartValue_AfterUpdate()

Dim strWhereCondition As String

    strWhereCondition = "[CATALOG] = '" &amp; Me!NextPartValue &amp; "'"
    DoCmd.OpenForm "_NextPartSearch", acFormDS, , strWhereCondition

End Sub
</code></pre>

<p>The code above brings up the correct part ONLY if the whole catalog number is typed in, otherwise it returns nothing. I've tried using <code>Like</code> statements, such as <code>strWhereCondition = "[CATALOG] = '" LIKE Me!NextPartValue &amp; "*"</code>, but none of them have worked. Any help would be appreciated! </p>