Hyperlink in query?

[CW]

Is it possible to make a value displayed in a query into a hyperlink?
For example we have a query that lists the sales invoices relating to each
of our orders, and it would be great to be able to click on a sales invoice
number and fire up the saved image of that invoice. Can do?
Many thanks
CW

 

[Arvin Meyer [MVP]]

Sure. But not in a query. Use a form based on the query. You can even use
datasheet view so it looks like a query output. Now you need to tell me what
the output is. I'll assume and Access report, and it could be as simple as:

DoCmd.OpenReport "Invoice", acViewPreview, , "InvoiceNumber =" &
Me.txtInvoiceID

 

[CW]

Arvin - that's great, thanks, and your guess at the doc I want to open was
very close - I modified that just slightly to suit my actual structure and
that was it
Thanks again
CW