On Open event of a report depending on the choice in Option box
I have an option box called Office in the form called FBenchmark.
In the OnOpen event of a report i want to have one record source in case that i have not selected something
from the option box, and another set of conditions for the record source in case i have selected from the Option Box
Which is the most professional way to do it?
I have tried the following
If Forms![FBenchmark]![office] = False Then
Me.RecordSource = strSource1
Me.RecordSource = strSource2
It does not work.