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

[Guest]

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

 

[Alex Dybenko]

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

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

 

[Guest]

Brillian Alex,

Many many thanks.

Adam

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

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

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