How to hyperlink from query to specific record in a specific form

[chaconne]

I want to hyperlink from a query direct to the relevant record in a specific form.

What is the best way to achieve this?

I have a hyperlink field in the form which shows up in the query. When clicked in the query, this hyperlinks to the form but I cannot make it select the correct record in the form.

How do I get it to select the correct record?

 

[CJ_London]

you wouldn't normally use a hyperlink to open a form in this way.

You should be using a form (could be a datasheet which looks the same as query results), not a query to display your data - in this way you can put code behind an event (e.g. click event) to open the form and display the right record.

 

[chaconne]

Thanks for this. I hadn't thought in this direction. Will experiment.

 

[Simon_MT]

I disagree providing the web information is mimicking the internal information. Obviously there are synchronisation issues but you should be able to open a web page looking at relevant records:

Function Web_OriginalsLarge()

    With CodeContextObject
        Dim WebLink As String
        WebLink = GetWebPath & "Originals_Multiple_Large.aspx?Stock=" & .[Orig Old Stock] & "&OL=1" & ""
        Application.FollowHyperlink WebLink, , True
        HideWebToolBar
    End With

End Function

Simon