Refreshing main form from a pop-up form

[Guest]

I have a main form (FRM_Projects) that has a button that opens a new pop-up
form (FRM_ED_WKSHT). The pop-up form has several questions, which generate a
score. This is working perfectly. However, when you close that popup and
return to the main form, I'd like it to show the results of the worksheet. I
can see the changes once I close the form and reopen it, but it's not working
otherwise. What event would you suggest that I put the
me.PPQA_Support_Level.Requery event onto? I've tried the On Avctivate and On
Got Focus, but neither seems to be working. Am I perhaps trying to tell it to
do the wrong thing?

 

[kingston via AccessMonster.com]

The trigger event should be in your pop-up form. You can use the form's .
OnClose event or the last control's .AfterUpdate event. Then use Forms!
FRM_Projects!PPQA_Support_Level.Requery. However, it sounds like something
else is missing because the On Got Focus event should work.

 

[Marshall Barton]

I have a main form (FRM_Projects) that has a button that opens a new pop-up
form (FRM_ED_WKSHT). The pop-up form has several questions, which generate a
score. This is working perfectly. However, when you close that popup and
return to the main form, I'd like it to show the results of the worksheet. I
can see the changes once I close the form and reopen it, but it's not working
otherwise. What event would you suggest that I put the
me.PPQA_Support_Level.Requery event onto? I've tried the On Avctivate and On
Got Focus, but neither seems to be working. Am I perhaps trying to tell it to
do the wrong thing?

If you are opening the popup form in Dialog mode, you can
place the requery immediately after the OpenForm line.

If that no acceptable for some reason, then put the requery
(with full form reference) in the popup form's Close event.