multi-select listbox

[pascal]

I know this question has been asked several times. I've searched the forum but I still can't solve the problem by myself. My VBA knowledge is not what it should be. So therefor I've included a simple database to this message. Can someone please solve my problem in this database and return me this database.

Problem: I want to select several artists in my listbox that must appear on my report which is based on a query.

Thank you in advance.

 

[Adrianna]

Pascal,
I have a question first....have you tried using a macro that generates reports using an OPTION group. So that the users are able to make the artist selection via a list and then print or preview the report from their selection?

 

[pascal]

Pascal,
I have a question first....have you tried using a macro that generates reports using an OPTION group. So that the users are able to make the artist selection via a list and then print or preview the report from their selection?

I think the list of artists is too big to do this through an option group. Therefor a listbox would be better. I really want to do it with VBA-code (For Each... In ... Next). Thank you.

 

[Adrianna]

I think this might help you:

Old posting on Printing Multiple Reports

if not...I've got a macro that is almost working in your database....it might take me another minute or two!

 

[Adrianna]

Solution!!

Okay...here is a fully functioning solution. I'm now working in Access 2000 and 2002 (no more 97), so I hope that you are able to use this!


P.S. I just realized after zipping that I should have included DoCmd.maximize After the OpenReport function

 

[pascal]

Once again, thank you for helping me out, Adrianna.

I'm afraid I'm still using Access '97 but I'm planning to upgrade to Access 2000. Or I can try it out at my work but then it won't be before next weekend. Anyway, I'll let you know what I think of it as soon as possible.

Bye