Hyperlink in query?

  • Thread starter Thread starter CW
  • Start date Start date
C

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
 
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
 
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
 
Back
Top