Open Report when clicking label for Text Box (1 Viewer)

I've done a little searching online but have not had much luck, so I'm hoping someone on the forum knows what to do ...

I have a form with multiple Text boxes. The Text Boxes are showing summary results, but I want to be able to load more detailed reports I have developed when I click on the label for each Text Box.

Is this possible, or do I need to use a different object to achieve this result?

you can use the click event on a label providing it is unbound. If it is bound to a control, then it will take its events from the control it is bound to.

to unbind a label, select it and delete it, then paste it again - it will probably appear top left of the form section it was in, so drag it back to where you want it

Sorted elsewhere, you should follow up when cross posting:

https://www.excelguru.ca/content.php?184