<div>
So you have a form called 'SearchF' and a combo box on that form called 'txtProcessedby'.<br />
Is this form a subform or the main form you open to run this query?<br />
<br />
Have you tried appending the property of the combo box?<br />
<br />
Like &quot;*&quot; &amp;&nbsp;[Forms]![SearchF]![txtProc<wbr />essedby]!v<wbr />alue &amp;&nbsp;&quot;*&quot;
</div>


So you have a form called 'SearchF' and a combo box on that form called 'txtProcessedby'.
Is this form a subform or the main form you open to run this query?

Have you tried appending the property of the combo box?

Like "*" & [Forms]![SearchF]![txtProcessedby]!value & "*"

<div>
It is the main form used to run the query. <br />
<br />
The criteria you posted did not work.
</div>


It is the main form used to run the query.

The criteria you posted did not work.

<div>
txtprocessedby is on the main form searchF.
</div>


txtprocessedby is on the main form searchF.

<div>
That worked, but I also have list value combo boxes that don't render the correct results.
</div>


That worked, but I also have list value combo boxes that don't render the correct results.

<div>
Actually it worked half way. It isnt showing all of the results
</div>


Actually it worked half way. It isnt showing all of the results

<div>
I deleted all the other query criteria. That colum bound fix worked. <br />
<br />
Why is the other criteria making my results incomplete?
</div>


I deleted all the other query criteria. That colum bound fix worked.

Why is the other criteria making my results incomplete?

<div>
<div class="content wysiwyg-content">
I have a form to setup a query criteria. I have a combo box on my form, but when I use that data to define query criteria it renders no results. See the image below.<a href="https://filedb.experts-exchange.com/incoming/2012/02_w06/549023/combobox.jpg" target="_blank" title="processed by (49 KB)"><img alt="processed by" class="file-block lazyload" style="max-width: 750px;" data-src="https://filedb.experts-exchange.com/incoming/2012/02_w06/549023/combobox.jpg" /></a><br />
txtProcessedby is my combobox<br />
<br />
The criteria I set for the query is<br />
Like &quot;*&quot; &amp;&nbsp;[Forms]![SearchF]![txtProc<wbr />essedby] &amp;&nbsp;&quot;*&quot;
</div>
</div>


combobox.jpg

I have a form to setup a query criteria. I have a combo box on my form, but when I use that data to define query criteria it renders no results. See the image below.

txtProcessedby is my combobox

The criteria I set for the query is
Like "*" & [Forms]![SearchF]![txtProcessedby] & "*"

Can't use a combo box to define query results in access 2010

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.

Microsoft Access

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.