Control Source as a Variable?

[jm112]

Is there a way to declare a control source as a variable?

I have a report filter like this:

DoCmd.OpenReport "report", acViewReport, , [site1] = "open"

I want [site1] , which is a control source, to change to [site2], [site3], [site4], depending on a value chosen in a combo box.

Thanks!

 

[RuralGuy]

Create your WhereCondition argument as a string and point to the string in the OpenReport command.