Option Filter and Reports

S

ScottF

I have an option filter in a form. I want to print message on a report based
on which option is selected.

if option1 then print message1
if option2 then print message2

Thanks for your help.

ScottF
 
O

Ofer Cohen

In the control source of the text field in the report where you want to
display the message, you can write

=IIf(Forms![FormName]![FieldName] = "Option1" ,"First Message","Second
Message")
 
F

fredg

I have an option filter in a form. I want to print message on a report based
on which option is selected.

if option1 then print message1
if option2 then print message2

Thanks for your help.

ScottF
Click to expand...

Add an unbound text control to the report.
Set it's control source to:

=IIf(forms!formName!OptionGroupName = 1, "Message1","Message2")

The form must be open when the report is run.
 
Top