Me.txtTextBox1 = Form_frmForm.txtTextBox2 Doesn't Work 1

[alexbel]

Hi,

In the report OnOpen Event, I have the following code:

Me.txtTextBox1 = Form_frmForm.txtTextBox2

For some reason it doesn't work. How can I make this work?

Thank you

 

[RoyVidar]

Try using the on format event of the section where txtTextBox1 resides, and, if the form name is frmForm, try:

[tt]forms!frmForm!txtTextBox2[/tt]

Roy-Vidar

 

[alexbel]

Hi Roy,

So I would put the following in the OnFormat Event:

Me.txtTextBox1 = Forms!frmForm!txtTextBox2

If this is right, it doesn't seem to work. Nothing just appears in the spot where the value should be.

Thank you

 

[RoyVidar]

In the on format event of the section where the control resides (detail?), yes. Is the form open, and the control having any data? The txtTextBox2 will also need to be unbound.

Or just use the expression in the controlsource of the control:

[tt]=Forms!frmForm!txtTextBox2[/tt]

Roy-Vidar

 

[alexbel]

Yes, that did it!

Thank you!