Option Filter and Reports

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

Guest

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
 
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")
 
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.
 
Back
Top