Consulting

Results 1 to 7 of 7

Thread: Link items on report to actual record(s)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Contributor
    Joined
    Jul 2011
    Location
    Manchester
    Posts
    119
    Location

    Link items on report to actual record(s)

    Hi

    I have only started using Access this year and set up a couple of databases for work. I have a report within one of them that shows open items and a colleague has asked if it is possible to create links on the report to open the relevant record. Can any one advise if this is possible and if so where I need to be looking to set it up. I have created several test reports to plays around and looked at setting but cannot see if this is possible.

    I can get the records form to open when i click the report but it opens at the first record irrespective of whether it is open or not. I tried changing the line to, DoCmd.OpenForm "Incidents", , , "ID = " & Me!ID thinking the ID would be picked up and the relevant record would open but i just get error message.

    The report form is called incidents, the report has an ID field called ID so if the user clicks on an incident in the report with ID 14 then it is record 14 i would like to open for them?

    Thank you

    Mykal
    Last edited by mykal66; 10-21-2019 at 02:12 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •