Using multiple critera in a listbox for a query

[Gabbelgak]

Is there a way to limit a result based off multiple columns populated in a listbox from a query?

A single result works easily but I want to be able to select a result from a listbox which will then populate another listbox with a query based off two fields in the first listbox.

Preferably without any VBA

 

[Micron]

Dont know what you mean by 'a single result works'.
You could reference the listbox and its columns in the second query. If the listbox is single select, I think the syntax is Forms!frmMyForm.lstMyList.Column, which you can specify as criteria in the second query. If the listbox is capable of multi select, that is a different story - you will be stuck with vba AFAIK.

Not using any vba also means you cannot prevent running the query if nothing is selected in the first listbox.