Value List info passed to a parameter query

[drewmayerson]

I have created an unbound value list with two columns on a form.&nbsp;&nbsp;When a value in column 1 on the form is chosen, I want the value in column 2 to be passed to a query.&nbsp;&nbsp;My query looks like this but I get no results, where am I going wrong?<br><br>[Forms]![RunProductionQueryForm]![List21]![Col2] Or IsNull([Forms]![RunProductionQueryForm]![List21]![Col2])

 

[Guest_imported]

set the bound column to 2 on the listboxes properties then refer to the form as normal<br>[Forms]![RunProductionQueryForm]![List21]<br>

 

[JimConrad]

Or try...<br><br>Note: Listbox columns are zero based index, so Column(0) refers to the 1st column...<br><br>[Forms]![RunProductionQueryForm]![List21].Column(1)<br> <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>