<div>
Thanks for quick response, unfortunately its not working...using expression builder...<br />
<br />
[forms]![fr_DailyWOMYPInsp<wbr />ectionSele<wbr />ction]![cm<wbr />b_AnnexDro<wbr />p] &nbsp;Or Is Null <br />
<br />
this returns just 2 blank rows and when selecting individual annexes it adds the blank rows....<br />
<br />
My combo box has the following list values, &quot;&nbsp;&quot;, 0600000, 1502000, 1602000, 1700000 and 1800000. Maybe instead of blank I need to have something else?
</div>


<div>
Maybe this will be easier with VBA code?
</div>


<div>
Thank you for your help. It worked perfectly. The problem was that I was adding empty line space in my combo box and it was not searching properly.
</div>


<div>
<div class="content wysiwyg-content">
I have a combo box on a form that passes 6 different annex number sets as parameters to the linked query. These numbers are 0600000, 1502000, 1602000, 1700000, and 1800000. The following line works perfect when selecting those numbers individually and after update, subform query gets refreshed and updated. 
<pre><code class="code-1 nolinks" id="code-10-28931090-1"><span>[forms]![fr_DailyWOMYPInspectionSelection]![cmb_AnnexDrop] </span>
</code></pre>
I also need to see all records from the query not just when I select individual annexes, and this is where I am having a problem. Currently this is the code I am using as criteria in the query, but its not returning any records when in the dropbox I select empty option, or even a * option. 
<pre><code class="code-1 nolinks" id="code-10-28931090-2"><span>IIf(IsNull([forms]![fr_DailyWOMYPInspectionSelection]![cmb_AnnexDrop]),&quot;*&quot;,[forms]![fr_DailyWOMYPInspectionSelection]![cmb_AnnexDrop])</span>
</code></pre>
Can anyone help me with what code I need to have these annexes displayed individually and all at the same time?
</div>
</div>


I have a combo box on a form that passes 6 different annex number sets as parameters to the linked query. These numbers are 0600000, 1502000, 1602000, 1700000, and 1800000. The following line works perfect when selecting those numbers individually and after update, subform query gets refreshed and updated. (CODE)
I also need to see all records from the query not just when I select individual annexes, and this is where I am having a problem. Currently this is the code I am using as criteria in the query, but its not returning any records when in the dropbox I select empty option, or even a * option. (CODE)
Can anyone help me with what code I need to have these annexes displayed individually and all at the same time?

How to view all records from combo box on form

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.