Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refresh Form Control Value Based on Value From Another Form Control

Status
Not open for further replies.

larrydavid

Programmer
Jul 22, 2010
174
US
Hello,
I have a popup form which has a textbox which gets its value from the textbox on another form like so:

=Forms.CC_frm_Analyst_Admin!ANALYSTNAME

This form is on top of the form where a user can change the value of this textbox. When this value is changed, I need to make the value refresh automatically. I have been trying to do this, on my own and based on some research I've done online, but am unable to get this to work without a manual refresh. I've tried working with the lost/got focus events adn so forth, but no go. Any help greatly appreciated.

Thanks,
Larry
 
Can you restate this more clearly?
"When this value is changed, I need to make the value refresh automatically."

If you mean you want the value of the control to equal the text in the control without leaving the control, then look at the controls change event and the text property.
 
Yes, without leaving the control. I assume I would look at the controls change event on the "other" form, not the popup? Could you please show me a quick example?
 
OK, I figured out a way. I just used the form's timer event and set it to one second. Works like a champ. Thanks for all your great help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top