How To Change Field To Hyperlink In SQL Query Results Table

[schreinman]

Hi All!

Here's my scenario: I have a search page where I use

===========================================
Set rs = db.OpenRecordset(strSQL, dbOpenSnapshot)

With db
Set qdf = .CreateQueryDef("tmpSearchResults", strSQL)
DoCmd.OpenQuery "tmpSearchResults"
.QueryDefs.Delete "tmpSearchResults"
End With
===========================================

... to open a recordset utilizing the SQL string that was built from the Search form. The first field I list in the results is AssetID.

Is there some way that I can get the results to return the AssetID as a hyperlink with the following code:

DoCmd.OpenForm "frmAddEditAssets", , , [AssetID] = 'value' (where 'value' is the number found in the AssetID column for each found record)

See attached screenshot of sample search results.

THANKS!!!

 

[Vistoro]

Hard to realise, give more info please.