Email Button

[Charno]

I have added an email button to a form 'Chill intake', which looks at the
field 'Haulier' and then looks up the email address for the haulier in a
table called 'Hauliers'. On click the button should open a blank email with
the hauliers email address in the 'TO:' field.

The form macro i'm using is =(DLookUp("[Email Address]","Hauliers","ID=" &
([Haulier],0)))

However when i click on the button it causes an issue that closes Access down.
Any Ideas?

 

[Daryl S]

Charno -

I think the ,0 after [Haulier] is a problem. I removed it. Try this (if
Haulier is a numeric):

=(DLookUp("[Email Address]","Hauliers","ID=" &
[Haulier]))

Or this (if Haulier is text):
=(DLookUp("[Email Address]","Hauliers","ID='" &
[Haulier] & "'"))