Multiple Check Boxes

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

Guest

Hello.

I have the following checkboxes in a form:[Disposition Other] [Disposition
Repair] [Disposition Rework] [Disposition Use as is]. In the report if
[..Other] is check I want have report print "O" for [...Repair];
"Rep", for [..Rework]; "Rew", and [...Use...]; "U". It is probably an iif
statement, but need a little help.

Thanking you in advance. Max
 
Max said:
I have the following checkboxes in a form:[Disposition Other] [Disposition
Repair] [Disposition Rework] [Disposition Use as is]. In the report if
[..Other] is check I want have report print "O" for [...Repair];
"Rep", for [..Rework]; "Rew", and [...Use...]; "U". It is probably an iif
statement, but need a little help.
Click to expand...

Try this kind of expression:

In the txtRepair text box:

=IIf([...Other], "O", [...Repair])

Just make sure that you name the text box something other
than the the name of the field.
 
Back
Top