Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

Access DB Hyperlinks

Hello,

I have created a query in my DB.  I want to add a hyperlink to each record produced in the query that will take me to that record in Form view.  Right now, I can create a hyperlink that takes me to the form, but not one that takes me right to the same record.  

A second thing I want to do is link groups of records in my main table so when I click on a hyperlink, it only brings up that group of records.  Can this be done?

Thanks,
John
0
jz1english
Asked:
jz1english
1 Solution
 
peter57rCommented:
Hello jz1english,

hyperlinks retrieve documents not data, so you cannot do what you ask because no document exists containing the data you want.

You can use a form datasheet to display the results of your query and then use a click or doubleclick event procedure for one or more of the displayed textboxes to open the form with the matching data.


Pete
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now