By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,158 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,158 IT Pros & Developers. It's quick & easy.

form value

ddtpmyra
100+
P: 333
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
Sep 19 '08 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,638
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:
Expand|Select|Wrap|Line Numbers
  1. Me![txtTest] = Forms!Form1![txtCapture]
Sep 20 '08 #2

ddtpmyra
100+
P: 333
I want it to assign in a variable
Sep 22 '08 #3

ADezii
Expert 5K+
P: 8,638
I want it to assign in a variable
Expand|Select|Wrap|Line Numbers
  1. <Your Variable> = Me![txtTest] = Forms!Form1![txtCapture] 
Sep 22 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.