how to make the text clickable in ms access?

[stellesv]

is there anyone here have an idea how to make the text clickable (and will open a new form)
for example


StudentNo

12345<---- if i click this one 12345 information such as name, age, course, year and etc. will show in a newform
12346


12347
12348
12349
12341

-i just dont have an idea, thank you

[amrut]

You can do it quite easily. If a text box/combo box is used to display the student number, the OnClick event will solve your purpose. You may change the "Display as Hyperlink property" to "Screen only" to look as as link. There are other ways too to achieve it.

How are the student numbers displayed ? Better option would be to use a combo box for the student number and a command button to open the form.

[tanvi]

Check this article, it has full information about hyperlink: http://office.microsoft.com/en-ca/ac...005188821.aspx

[pbaldy]

How about:

BaldyWeb wherecondition