Hyperlink from field to form

[adame]

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

[ranman256]

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.

[adame]

Thanks I will try this. i have never really used VBA code so I am not hopeful!

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.

[orange]

You may get some ideas from these free generic data models from DatabaseAnswers.org

http://www.databaseanswers.org/data_...ters/index.htm
http://www.databaseanswers.org/data_...ents/index.htm
http://www.databaseanswers.org/data_...ents/index.htm

Here is a link to info that should help you with concepts and approach.
Good luck.

[adame]

Many thanks - I will check out those links.