Where are you (?proposing to be?) selecting this option?

If you use a form to "collect" your criteria, then open a report, the report
could "look" back at the form to set values.

You could even have a single label and change the "Caption" property's value
to whatever fit...

Good luck

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"kary via AccessMonster.com" u57638@uwe wrote in message
news:a6f2245ba3734@uwe...
Hi

Is it possible to make a label visible during the OpenReport command? I
have
the following commands:

If option 1 is selected --
DoCmd.OpenReport stDocName, acPreview, , "M1Ass1Comment='Fail M1Ass1'"
If option 2 is selected -
DoCmd.OpenReport stDocName, acPreview, , "M1Ass2Comment='Fail M1Ass2'" ,
etc

However, I would like a different label on the report to be visible
depending
on the selection. Is On Load the only way to achieve that?
Thank you
Kary

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201004/1