Results 1 to 5 of 5
  1. #1
    adame is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    9

    Hyperlink from field to form

    Hi,

    I am putting together a student record system. I have a student table and a subform which displays info from another table showing what modules they are taking - every student record displays the two or three relevant modules.

    I also have a separate module information form that shows for each single module, the list of students enrolled, the room number etc.

    I would like to be able to click any of the two or three modules a single student is taking (in that student's subform) and to be taken to whichever relevant module I've clicked (in the relevant module information form), to see all the students, the room etc for that particular module.

    I'm amazed I've got this far. Is there an easy way to describe how I might do this next step?



    Thanks,

    Adam

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,837
    Make a form for each data set you want to see.
    if you are on the student , and see his modules in a subform,
    click a module, click button to jump to the module screen via:

    docmd.openform "frmModules",,,"[ModId]=" & me.Modid

    this will open the module form to see all persons in the module.

  3. #3
    adame is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    9
    Thanks I will try this. i have never really used VBA code so I am not hopeful!

    Quote Originally Posted by ranman256 View Post
    Make a form for each data set you want to see.
    if you are on the student , and see his modules in a subform,
    click a module, click button to jump to the module screen via:

    docmd.openform "frmModules",,,"[ModId]=" & me.Modid

    this will open the module form to see all persons in the module.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,509

  5. #5
    adame is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    9
    Many thanks - I will check out those links.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-20-2016, 02:33 PM
  2. Convert Hyperlink field to Text
    By izzo248 in forum Access
    Replies: 3
    Last Post: 08-24-2015, 08:44 PM
  3. Hyperlink Field Custom Formatting?
    By excellenthelp in forum Access
    Replies: 1
    Last Post: 08-12-2014, 02:02 PM
  4. Replies: 9
    Last Post: 06-12-2014, 01:36 PM
  5. Replies: 3
    Last Post: 11-05-2013, 01:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums