I need to refresh!!

[raychoy2k]

I have a form that opens a popup, then when the popup is closed I would like the form to refresh so it can reflect the changes made.

(The popup makes changes to the subform in the original form. It would be nice to have it refresh and show new changes one I go back to the form)

I tried OnActivate and OnCurrent. Neither work. Any suggestions?

Thanks from Newbie Man!

 

[Vassago]

Does it change the query that the subform is bound to. Look at this: I had a similar situation and this should help you out:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=45245

Let me know if that helps,

Vassago

 

[jfgambit]

Try adding the following on the On Close event of the POP-UP:

[Forms]![NameofForm].Refresh

or

[Forms]![NameofForm].Requery (if it is built from a query)

HTH

 

[raychoy2k]

Yo JF, you are right.

I think that should work. Let me try.

I feel stupid for no thinking of that one. I did a refresh with the OnActivate on the original form instead.

It doesn't use a query, so a requery will not help in this case.

Thanks for the suggestions though.

 

[jfgambit]

Pat:
Note how I put:

(if it is built from a query)

Since it was not stipulated how the form was built I suggested both.

You clarification is noted.

 

[tpickles1984]

Quite an old thread, but I have a suggestion if it's still wanted. I would use the .Recalc command at the end of the expression. This seems to do what you're wanting!

 

[Rosco4]

something that simple

Thanks for the info on Shift-F9 and F9. It is exactly what I needed to resolve my issue I was having on a subform that needed to be 'refreshed' with new data added to the primary form.