View Single Post
  #1  
Old November 17th 08, 10:35 PM posted to microsoft.public.outlook.program_forms
Sandi V
external usenet poster
 
Posts: 7
Default 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
Ads