Referencing multiple check boxes.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have the following expression in one of my reports:

=IIf(Reports!rptATD!chkProgramPrinter=True,"Sponsor","TUSAFB")

I need to also reference another field on the same report (either
txtPrintedProgram or chkPrintedProgram) so that the above string does not
display if the chkPrintedProgram is no. I've tried several different things,
but nothing seems to do it. I'm not a pro at this, so any help would be
greatly appreciated.
Thanks,
Bullmann
 
Hi Bullman,

you can nest IIF statements

=IIf(Reports!rptATD!chkProgramPrinter,
IIf(Reports!rptATD!chkPrintedProgram,"Sponsor","TUSAFB"),"")

where is this equation?

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
Crystal,
Thanks so much!! I've been trying to figure this out for months. I had to
switch the chk references around, but the nesting worked. This expression is
in a report that gives our band information about the concert site where
they'll be playing. This particular field tells them if there will be a
program and who's printing it.
Thanks again,
Bullmann
 
Hi Bullman,

you're welcome

If this code is behind the report you are referencing, it is
better to use Me. instead of the full reference

Reports!rptATD!chkProgramPrinter
--> Me.chkProgramPrinter


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
what kind of double iif expression is this?

n.b. ma ze ha bs"d haze
--
Thankfully, YisMan


Ofer said:
Try

=IIf([chkPrintedProgram] = False , ""
,[chkProgramPrinter]=True,"Sponsor","TUSAFB"))

--
\\// Live Long and Prosper \\//
BS"D


Bullmann said:
Hello,
I have the following expression in one of my reports:

=IIf(Reports!rptATD!chkProgramPrinter=True,"Sponsor","TUSAFB")

I need to also reference another field on the same report (either
txtPrintedProgram or chkPrintedProgram) so that the above string does not
display if the chkPrintedProgram is no. I've tried several different things,
but nothing seems to do it. I'm not a pro at this, so any help would be
greatly appreciated.
Thanks,
Bullmann
Click to expand...
Click to expand...
 
I didn't notice I missed the second IIf, thanks for noticing

=IIf([chkPrintedProgram] = False , ""
,IIf([chkProgramPrinter]=True,"Sponsor","TUSAFB"))

Sof Sof mishehu sam lev, Kol Hakavod.

--
\\// Live Long and Prosper \\//
BS"D


YisMan said:
what kind of double iif expression is this?

n.b. ma ze ha bs"d haze
--
Thankfully, YisMan


Ofer said:
Try

=IIf([chkPrintedProgram] = False , ""
,[chkProgramPrinter]=True,"Sponsor","TUSAFB"))

--
\\// Live Long and Prosper \\//
BS"D


Bullmann said:
Hello,
I have the following expression in one of my reports:

=IIf(Reports!rptATD!chkProgramPrinter=True,"Sponsor","TUSAFB")

I need to also reference another field on the same report (either
txtPrintedProgram or chkPrintedProgram) so that the above string does not
display if the chkPrintedProgram is no. I've tried several different things,
but nothing seems to do it. I'm not a pro at this, so any help would be
greatly appreciated.
Thanks,
Bullmann
Click to expand...
Click to expand...
Click to expand...
 
Back
Top