form value

[ddtpmyra]

Hi,

I have two forms open at the same time lets call it the form1 and form2. While currently the user working on form2 and form1 is on the background opened I want to captured the value of text on form1. How can I do that using vba code?

thanks
DM

[ADezii]

Let's assume that you are working in Form2, and you wish to capture the value in a Text Box on the opened Form1 named txtCapture, and place it in a Text Box in Form2 named txtTest:

Me![txtTest] = Forms!Form1![txtCapture]

[ddtpmyra]

I want it to assign in a variable

[ADezii]

I want it to assign in a variable

<Your Variable> = Me![txtTest] = Forms!Form1![txtCapture]