Hyperlinks in report

[grego9]

I am trying to add a hyper link to a report in access.

I need the hyper link to change depending on the name of the business unit that the report is run for.

The Report is based on a query (Business Unit Select) which prompts for a Business Unit name via a Form combo box (combo0).

So the report is just for that particular business unit

The main path for the hyper link is Q/Data/

I then want the path to be

Q/Date/[Name]

Where Name is the name of the business unit as described in the query

Any ideas on how to get this to update every time a new business unit is chosen?

thanks

 

[ByteMyzer]

You can't implement hyperlink functionality in a Report. You can, however, use it in a Form.

What is it that you are trying to accomplish?

 

[boblarson]

You can't implement hyperlink functionality in a Report. You can, however, use it in a Form.

What is it that you are trying to accomplish?

Actually, Byte I think you can in 2007 because reports in 2007 have clickable events now. I can't answer how until I would be able to get to my 2007 installation at home as I'm now at work with no 2007 available to me yet.

 

[ByteMyzer]

Ahh, yes, you're right, Bob. I had my head stuck in A2K3 mode. I haven't looked at this in A2K7, myself; I'll be curious to see what you find.

 

[grego9]

I am using Access 97 - so well and truly in the dark ages!

thanks for the response. I assume I could create the hyperlink creator in the form and then save the result in the table which I could then display in the report.

So my question is now how do I create a hyper link in the form with a changing element to the hyper link? So the hyper link will have a standard path (eg d:/) and then the name of the business unit - which is a item on the form

thanks