Adding IIF to a report

J

jderrig

I have a report that is tied to a dialog box form that is
run by a macro. My dialog box form allows me to select an
option box and then select an area from a combo box to
filter the report (or leave combo box blank to see all
records). I would like to put a text box on the report
that specifies "All" records if I leave the combo box on
the form blank. I currently have the report set up with a
text box that is controlled by the Area field but when I
want all the records, it is mislabeled.
 
Top