Email link problem, help appreciated

  • Thread starter Thread starter james
  • Start date Start date
J

james

Using Access 2000
I have been using the following code in a text box:

Private Sub Email_Address_DblClick(Cancel As Integer)
Application.FollowHyperlink "mailto:" & Me.FieldName
End Sub

It has been working fine for a long time. Now I have a new database where I
am using that code in a sub form and I get this error:

"The Expression On Dbl Click you entered as the event propertry setting
produced the following error: A problem occurred while Main Menu was
communicating with the OLE server or ActiveX control."
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro.

My Sub form is DistributionEmployees and is nested inside Distributor.
Distributor is accessed from a switchboard form called Main Menu.

Any help greatly appreciated.

Thanks!

James
 
It appears your are not referencing the field on the
subform correctly.
Try
[Forms]![mainformname]![subformname].[Form]![controlname]

Jim
 
Back
Top