setting control source of text boxes during runtime

[Diane]

I am creating a report that accepts an input from the
user and uses that input to determine what values the
text boxes on my report will be looking up. I want to
simply be able to set the control source of the four text
boxes once I get the user's input. I know you can do
this in a form, but is it possible in a report? What
report event should I set the control source for the text
boxes in?

Any help would be appreciated! Thanks!

 

[Marshall Barton]

I am creating a report that accepts an input from the
user and uses that input to determine what values the
text boxes on my report will be looking up. I want to
simply be able to set the control source of the four text
boxes once I get the user's input. I know you can do
this in a form, but is it possible in a report? What
report event should I set the control source for the text
boxes in?

The only event you can use to do this in a report is the
Open event.