Hyperlink from Forms to Reports in same database

[Sweets]

Hi,

I have a form created with thousands of entries. In the same database I have created many different reports. What I want do to is, create a hyperlink in each row of the form to different reports. so that I have at the end one link to each report from a different row.
I can"t find anything about that. Is that possible. If yes, how?

Thanks for your help!

 

[Zaeed]

Why do you want this to be done with hyperlinks? If its all in the same database just make a button to open the report

 

[boblarson]

If you want it to LOOK like hyperlinks you can have it so that you just use a text box formatted as transparent and with the Is Hyperlink property set to yes to get the hand icon. Then you can format the words to blue and underlined and then in the click event use DoCmd.OpenReport "YourReportNameHere", acViewPreview

 

[Zaeed]

That sounds like calling a taxi to cross the street. It would be far easier to simply code it to a button, so that when you click the button it opens the report

 

[boblarson]

That sounds like calling a taxi to cross the street. It would be far easier to simply code it to a button, so that when you click the button it opens the report

Yes, that may be, but sometimes you want to do certain things with a bit of visual creativity and maybe that's the case here. It isn't always about efficiency (although I agree that is one of my primary targets when doing things).

 

[Sweets]

Thanks for your advices. \
I have just learned Access, that's why I didn't know that.
I have created a button, but when I create it I do that in design view, which means that I have the same button in every row and therefore a link to the same report. But that's not what I want. I want to have different buttons with which I can open different reports. And in some rows I don't want any buttons. So how can I do that?

 

[boblarson]

Maybe my posts here will help you (look for my posts within this thread):
http://www.access-programmers.co.uk/forums/showthread.php?t=140588