Iif statement on mail form
 

I'm designing a mail form for conference room reservations. The composer
checks Y/N checkboxes if they need food, beverage, laptop or projector. If
both projector and laptop are unechecked, I want the cc text box to remain
blank. Otherise, I want to populate the cc text box with my own email
address. I've tried to change the datasource to:

IIf([Projector]=0 and
")

I've experimented with all kinds of parenthetical placements and keep
getting syntax errors (missing brackets, missing parens, etc.). I hope
someone can help. Thanks. -- Sandi

Iif statement on mail form
 

I got it: Here's what worked: I can't see what's different than the original
other than the AND is all caps. Guess that matters.

IIf([Projector]=0 AND ")

original:
IIf([Projector]=0 and ")


"Sandi V" wrote:

I'm designing a mail form for conference room reservations. The composer
checks Y/N checkboxes if they need food, beverage, laptop or projector. If
both projector and laptop are unechecked, I want the cc text box to remain
blank. Otherise, I want to populate the cc text box with my own email
address. I've tried to change the datasource to:

IIf([Projector]=0 and
")

I've experimented with all kinds of parenthetical placements and keep
getting syntax errors (missing brackets, missing parens, etc.). I hope
someone can help. Thanks. -- Sandi