Refreshing main form from a pop-up form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
RebeccaMinAR said:
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?
Click to expand...


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.
 
Back
Top