How to assign a value to a Textbox in Report PageHeader

[raabbasi]

I want to assign a value, from a textbox in a form, to the textbox in the PageHeader of a report. I have tried many variations of the following syntax, but all failed:

Me.Section(acPageHeader)!txtSupplier= Forms!frmCriteria!cmbSuppliers

Seeking help.

 

[Remou]

Hi
You can set the Control Source to:
= Forms!frmCriteria!cmbSuppliers

Or you can say:
Me!txtSupplier= Forms!frmCriteria!cmbSuppliers

(Assuming the form is open! )

 

[RoyVidar]

You don't need to refer through the section, but just:

[tt]me!txtSupplier = ...[/tt]

You could also just use the form reference in the controlsource of the control, but

- we don't know which event you are using, what error you're getting...

should it still not work, my guess would be wrong event, try the on format event of the section.

Roy-Vidar

 

[raabbasi]

If I use the following statement in Report_Open event:

Me!txtSupplier = Forms!frmCriteria_StockSummary!cmbSuppliers

Then I get the following error:
"You can not assign a value to this object."

Although, I can solve my problem by assigning;

= Forms!frmCriteria!cmbSuppliers

to the ControlSource property of the Unbound Textbox, in the ReportHeader, on the Properties sheet.

But, I want to find out the way to code it inside the Code module.

 

[Remou]

Hi
You must first clear the Control Source, if you wish to use code to assign the value. That is, the control must be unbound.

 

[RoyVidar]

I alredy answered your last question in my previous reply, here with a bit more detail - you can't assign values to controls in the on open event of the report. One would usually use the on format event (and sometimes, the on print event) where the control resides.

Roy-Vidar

 

[raabbasi]

Thanks Remou and RoyVidar for your help.