<div>
See if this helps you proceed.<br />
Combo99 rowsource is a select statement for Field:fld from Table:tbl.<br />

<pre><code class="code-10 nolinks" id="code-20-41861098-1"><span>Private Sub Combo99_Change()</span>
<span>    Dim ct As String</span>
<span>    ct = Combo99.Text</span>
<span>    Combo99.RowSource = &quot;Select fld from tbl where adesc like &quot;&quot;*&quot; &amp; ct &amp; &quot;*&quot;&quot;&quot;</span>
<span>    Combo99.Undo</span>
<span>    Combo99.Requery</span>
<span>    If IsNull(Combo99.ItemData(1)) Then</span>
<span>        Combo99.value = &quot;Not exist&quot;</span>
<span>    Else</span>
<span>        Combo99.value = Combo99.ItemData(1)</span>
<span>    End If</span>
<span>End Sub</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I have a combobox on a form and the AutoExpand = Yes works fine. &nbsp;But what I would like it for the combobox to &quot;find&quot; a selection based on what I'm typing. &nbsp;For example, if one of the choices possible is &quot;United Stated Football&quot;, and if I start typing &quot;Foot&quot; it will find that record and allow me to use it.<br />
<br />
Possible?
</div>
</div>


I have a combobox on a form and the AutoExpand = Yes works fine.  But what I would like it for the combobox to "find" a selection based on what I'm typing.  For example, if one of the choices possible is "United Stated Football", and if I start typing "Foot" it will find that record and allow me to use it.

Possible?

How fill a combobox when any part of a possible selection is being typed

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.