I currently have a table that utilises a hyperlink field. The field
currently links to a form using the following default value "form
frmCand##form frmCand". I would like the hyperlink in each record to
go to the corresponding record in a particular form. Is this possible
through a hyperlink, or is there a possible alternative?

Apparently filemaker pro can do this and i was wondering if access can
do the same.