Reference report controls in custom code 1

[daveonion]

Hi is there a way to reference the controls on the report in the custom code, ie if i write a procedure how do you say textbox1.value = blah

thanks

 

[xlbo]

ReportItems!Textbox1.Value

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[daveonion]

Hi Geoff,

Thanks for your reply, just one quick question is reportitems a constant or is it meant to be replaced with the name of the report, also is it possible to reference other reports from one report. Thanks again

 

[xlbo]

ReportItems is the collection of controls within the current report so you just need to change the name of the control you are referencing

You cannot reference controls in another report

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question