Multiple choice selection

[Moridan]

Perhaps something is wrong with how my network is configured. I put in the above code into your Multi-select code and it doesnt work properly. It works for the first time I make a selection but if I try to open a report with different selections, it ends up opening the same report again from the previous selection and then opening the acPreview report as well....



Is there something that I am missing?

[Moridan]

Maybe there is a command that will "clear out" the fields...? I have to close out my Access completely for it to reset. 9-(

[pbaldy]

Are you closing the report after outputting or emailing? If not, the same report will be hidden and it won't be updated with new selections. Since it's hidden, it won't be obvious what's going on.

[Moridan]

Ahh, let me try...

[Moridan]

Ok, that did it! I hadnt used the DoCmd.Close function on my other network.

Golden!

Have a great weekend!

[pbaldy]

Happy to help, and you too!