<div>
I get a mismatch type error. &nbsp;My field is a text field. &nbsp;<br />
<br />
Also the list box's query is set to prompt me for the specific job numbers that I am looking for but the actual report is based on a different query (unmatched) that shows the parts that haven't been used yet for the jobs that I picked in the list box and this is a different query all together.
</div>


<div>
You'd need to add single quotes, then:<br />
<br />
For each var in YourListbox.ItemsSelected<br />
&nbsp; s = s &amp;&nbsp;&quot;'&quot; &amp;&nbsp;YourListbox(0,var) &amp;&nbsp;&quot;',&quot;<br />
Next var
</div>


<div>
I'm still getting error 13 - type mismatch.<br />
<br />
This is the line that it's highlighting...<br />
<br />
&nbsp;s = s &amp;&nbsp;&quot;'&quot; &amp;&nbsp;YourListbox(0,var) &amp;&nbsp;&quot;',&quot;<br />
<br />
And yes I did change the name to what my listbox is called.
</div>


Filtering-by-Listbox-Selections.jpg

<div>
Helen,<br />
<br />
I'm going to try this but it seems very complicated. &nbsp;I'm good with Access but not that good.
</div>


<div>
Helen,<br />
<br />
I'm sorry I just don't know enough about this to continue. &nbsp;I really like the idea because it's exactly what I want but mine uses an unmatched query from two different tables and then also has a parameter when you first open the form to only pull up a certain job and then the list on the form would only show the lot numbers for that job. &nbsp;What I'm basically trying to do is compare the two table to make sure that nothing was left off of the packing list.<br />
<br />
Thanks
</div>


<div>
Are you checking that the form's record source is the same as the listbox's row source? &nbsp;The simplest way to do this is to use the same record source for both.
</div>


<div>
I would do that but I can't even get that far because I don't know that much about Access. I don't think I can use the same query for the record source because the query has a parameter for the job number.<br />
<br />
Maybe I'm going about it the wrong way. &nbsp;I want to be able to do is this...<br />
<br />
1. &nbsp;Open the form and it prompts for the job number<br />
2. &nbsp;This will show only the Lot IDs (lstLOTS) that don't match up between qryUnmatched (which compares qryVisual and tblContainer)<br />
3. &nbsp;Then I can pick the Lot ID (lstLOTS) and have it show me the mismatched parts in the subfilterform.<br />
<br />
I'm not sure how to do it since I'm working with a query and not an actual table.
</div>


<div>
Helen,<br />
<br />
I got my form setup to use your multifilter form and everything looks right. &nbsp;I ended up using my unmatched query to create the table that I needed but when I run the filter it gives me the following error...<br />
<br />
Sub or function not defined <br />
<br />
and it highlights CreateAndTestQuery<br />
<br />
Lori
</div>


<div>
I got it. &nbsp;I forget to add the basUtilities module. &nbsp;It works great now. &nbsp;Thanks so much to everyone.
</div>


<div>
<div class="content wysiwyg-content">
I have created a form based on a query which prompts for a job number and filters the records displayed based on the &nbsp;value entered. The form opens with an unbound list box which is based on an unmatched query that will allow me to select more than one record . &nbsp;I want to be able to pass these choices to a report so that I can see if any parts were missed on the jobs I've selected.
</div>
</div>


I have created a form based on a query which prompts for a job number and filters the records displayed based on the  value entered. The form opens with an unbound list box which is based on an unmatched query that will allow me to select more than one record .  I want to be able to pass these choices to a report so that I can see if any parts were missed on the jobs I've selected.

Use a list box to select multiple records and open in report

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.