Filter query by multi select listbox

[AccessDev]

Dear All,

I am just starting out in Access Development. I have a database that runs a logistics department. This was working fine until the users wanted a little more tweaking.

The report prints out the vehicles with all corresponding drops. This comes out all on sheet.

Is there a way that I can create a form to filter the report via a multi select listbox and print each drop selected on a seperate sheet of paper.

I am using Access 2003

Many thanks for any help or source code given

 

[MStef]

Hello Dev!

Look at "DemoLBColumnA2000.mdb" (attachment).
Open Form2 and try.

 

[Vitrivius]

Thanks. I'm also looking for a similar solution.

Is it impossible to build a query like this with the querybuilder?

 

[RV]

Is it impossible to build a query like this with the querybuilder?

For the query that comes with Form2 you mean?
You'll definitely need VBA to build your criteria and pass the selected values to the query.

Rv