List Box Conundrum

[Stigm@t@]

Hi

I have done a lot of reading on the site and tried everything i could find that i thought would work, but with no luck.

Here is my problem.

I have a single report that based on a selection of a form will print the report for the selected machine. So what i am wanting to do is have a list box with all the machines in it, the user will then select the machines that they need reports on. I would like to then click a command button and have the report print for each of the selected machines in the list box.

So the report will cycle through the selection and print.

Is this possible?

Best Regards
Stigmata

 

[MStef]

Hello Stigmata!

You have to make a query, and link Report on query.
Look at "DemoLBCColumnQryA2000.mdb".
Look at queris, Form2, Report1.
Open Form2 and try.

 

[Stigm@t@]

Hey MStef

Thanks for the demo and advice. Will give it a try night.

Regards Stigm@t@

 

[36Rock]

ListBox for Report

Hi MStef,

I used your example (which worked great) but I'm still having one little problem that I don't seem to be able to resolve. I'm getting a mismatch in query field. I realize its my ID it's looking for but I'm don't know how to make it look for the description name and not my id field.

Do you have any idea's on this problem that may help?

thanks so much,

36Rock