=IIf QUESTION

[Mihael]

Hello. I am kind of newbie in Access and there is problem that i cannot solve alone.
I am using a template of issues system and it has an email function. When the report is written and the user clicks the E-mail button it automatically writes fills the email in Outlook. Everything is clear, but i cannot add another form in the "Message text"

The text now is =IIf([Form].[Description].[TextFormat]=1;PlainText([Description]);[Description])



I want to add the information from field called "AWB", not just "Description" field. I need them both.

Can you tell me what should i write?

Thanks in advance!

[pbaldy]

You can concatenate form references and literal text together with &:

=IIf(...) & " whatever " & Forms!FormName.TextboxName

[Mihael]

Thank a lot.

[pbaldy]

No problem, and welcome to the site by the way!