Query Criteria

[tinker]

I have a report with a Subreport. The subreport is based on a query, the query has a criteria on a field called continent which relates to a multiselect listbox located on the selection form.
The listbox is populated with continents of the world
e.g
Europe
Asia

I need to be able to select more than one Continent, and for the query to bring back the desired information. E.g if I selected Europe and Asia, I want it to bring back records where the Continent field = either Europe or Asia (this doesnt seem to work by referencing the listbox as the criteria in the query)

Hope this makes sense as im not very good at explaining things.

Any ideas how to do this, Any help would be very appreciated

 

[Mile-O]

Here's a quick solution done on a form...