Setting Subject and other simple text properties

[Tim Miller]

Simple question I'm missing here:
I'm creating an appointment in Outlook from a command button in Access.
I'm trying to fill the subject and body in this code.

This works by giving the data from that Access form in the Subject:
Item.subject = [Forms]![Product Display Form]![ProductKey]

This, and many renditions of this result in a type mismatch error:
Item.subject = [Forms]![Product Display Form]![ProductKey] And " - Reserved"

That is, when I try to put text with my access fields, it doesn't work.

Can anyone tell me how to put this in?
Thanks
Tim

 

[Cheryl Fischer]

Tim,

This, and many renditions of this result in a type mismatch error:
Item.subject = [Forms]![Product Display Form]![ProductKey] And " -

Reserved"

Try this:

Item.subject = [Forms]![Product Display Form]![ProductKey] & " - Reserved"

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Simple question I'm missing here:
I'm creating an appointment in Outlook from a command button in Access.
I'm trying to fill the subject and body in this code.

This works by giving the data from that Access form in the Subject:
Item.subject = [Forms]![Product Display Form]![ProductKey]

This, and many renditions of this result in a type mismatch error:
Item.subject = [Forms]![Product Display Form]![ProductKey] And " - Reserved"

That is, when I try to put text with my access fields, it doesn't work.

Can anyone tell me how to put this in?
Thanks
Tim

 

[Tim Miller]

Thank was the ticket... thanks! I knew it was something silly simple.

Tim,

This, and many renditions of this result in a type mismatch error:
Item.subject = [Forms]![Product Display Form]![ProductKey] And " -

Reserved"

Try this:

Item.subject = [Forms]![Product Display Form]![ProductKey] & " - Reserved"

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Simple question I'm missing here:
I'm creating an appointment in Outlook from a command button in Access.
I'm trying to fill the subject and body in this code.

This works by giving the data from that Access form in the Subject:
Item.subject = [Forms]![Product Display Form]![ProductKey]

This, and many renditions of this result in a type mismatch error:
Item.subject = [Forms]![Product Display Form]![ProductKey] And " - Reserved"

That is, when I try to put text with my access fields, it doesn't work.

Can anyone tell me how to put this in?
Thanks
Tim