How do you pass on a field entry in an email message?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 15 Nov 2006 17:27 GMT

Hello all,

I've created a form in which I have a button which sends an email out to a
user. In that email, I'd like to reference the form number of that particular
form. I tried the following for my message column:

strMsgBody = "Issue no.[table1]![Database Reference No] A Technical Issue
pertaining to ......

Where table 1 is my table and Database Reference No is a unique identifier.

Many thanks in advance.

Adam
P.S. Am going home now so will check this forum again tomorrow

Reply to this Message

Alex Dybenko - 16 Nov 2006 08:36 GMT

Hi,
if you have this reference number on a from - then you can use it instead:

strMsgBody = "Issue no." & forms![MyForm]![Database Reference No] & " A
Technical Issue ...

As for table - then you can use DLookup() function to get a desired field
value from a table

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hello all,
>
[quoted text clipped - 13 lines]
> Adam
> P.S. Am going home now so will check this forum again tomorrow

Reply to this Message

Adam - 16 Nov 2006 09:47 GMT

Brillian Alex,

Many many thanks.

Adam

> Hi,
> if you have this reference number on a from - then you can use it instead:
[quoted text clipped - 22 lines]
> > Adam
> > P.S. Am going home now so will check this forum again tomorrow

Reply to this Message