Open Report when clicking label for Text Box

[russdwright]

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?

[pbaldy]

In the click event of the label:

DoCmd.OpenReport "ReportName, acViewPreview

[ranman256]

text boxes are bound to the form ,which is bound to the query.
you want to load a report when you click a label?

make a table of reports.
in the form , show them in a listbox.
dbl-click the item in list to have it open the report.

[davegri]

If a label is attached to a textbox, it has no events exposed.
So, delete the entry in yellow and the label becomes clickable.

[russdwright]

Figured it out!

[Missinglinq]

In the click event of the label:

DoCmd.OpenReport "ReportName, acViewPreview

As ranman256 said, there are no events for attached Labels.

If it were me, I'd simply use the DoubleClick event for the Textbox itself to run the code.

@russdwright: Forum etiquette requires that when the original poster independently finds a solution to the posted problem, that solution be posted. This helps others who may find their way to the thread solve similar problems.

Linq ;0)>

[CJ_London]

sorry guys, you've been wasting your time - cross posted here

https://www.access-programmers.co.uk...84#post1591184

OP advised of the etiquette but has not had the courtesy to advise you of that fact.