hyperlinks

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

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.
 
Jon,

Access can certainly do this. This is very routine for
Access, but not with the method that you are using. It is
usually done with VBA coding behind a combobox or a command
button. Macros can also do this, but VBA is usually the
preferred method.

With the method that you are using I would think that you
would need to code the ID# of each record into it's
hyperlink data. Using VBA you just reference the ID or
another field that you want for the criteria when you open
the form. Here is an example of what it looks like. The key
command is the DoCmd.OpenForm.... Look it up in Help...

Private Sub cmdActionItems_Click()
On Error GoTo Err_cmdActionItems_Click

Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "[ActionID] = " & Me!ActionID
stDocName = "frmActionItems"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdActionItems_Click:
Exit Sub

Err_cmdActionItems_Click:
MsgBox Err.Description
Resume Exit_cmdActionItems_Click

End Sub


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top