Report Server Hyperlink to Access record

[Cybersurfer]

I have an Access frontend with a SQL backend and generating reports with the SQL data through a reports server.

My question is I would like to put a hyperlink on the primary key in my report that would open Access and filter to the ID clicked on.
Thanks in advance any help would be greatly appreciated.



Rich

[ItsMe]

If you are talking about hyperlinks...

I would create a surrogate key rather than use the Primary Key as a hyperlink. I would also have the column formatted as text and not a hyperlink type. Use properties or Application.Followhyperlink method to translate literal text as hyperlink.

I don't think you are talking about hyperlinks. What is a Report Server?