hyperlink including variable parameter?

[Zarty]

I can create a hyperlink from an Access form to open a web page from a URL no problem but can anyone advise the best way to pass the value of a field on the form as a parameter in the URL? For example, a normal URL hyperlink might look like this...

http://[server]/reportserver?MyReport

The parameterised URL might look like this...

"http://[server]/reportserver?MyReport&rs:Command=Render&ID=999

The ID parameter is on the same form, field name "ID" for example. Could the parameter be handled in a normal hyperlink so I could have two hyperlinks, one to the report without paramters and one to the same report but with a parameter?

Thanks,
Zarty

 

[Zarty]

I solved it myself. From within code you can refer to the hyperlink's "Hyperlink Address" property...

Me.ReportForDeal_hyperlink.HyperlinkAddress = "http:\\someURLpath&ID=" & Me.ID.Value

where Me.ID.Value is the field on the form, which is the parameter to pass.

Still have an open quesiton about doing this in reverse... Opening an Access form from the command line on a specified record passed by parameter. Seems to be a bit trickier than this question!

Cheers,
Zarty