Requery

[destinman via AccessMonster.com]

I can click a command button on Form1 to take me to Form2. I add new data on
Form 2 and click a command button to go back to Form1. How do I get a
specific field on Form1 to be updated from what was entered previously on
Form2 ? I simply can not get Form1 to be requeried. I am doing something
basically wrong. Please Help !!

 

[John]

In the on click event of your button on Form2, you could put the following:


Forms![Form1]![ControlName].Requery


Of course, replace ControlName with the name of the control that you
want to requery. Also, this will only work if Form1 is already open, but
I'm assuming that's the case since if the button actually re-opened the
form, the control would automatically requery.