What event to refresh subform ???

[Steff_DK]

I'm trying to refresh a subform on the main form after updates or deletes has been done from an edit form.

I tried putting it in an OnGotFocus event on the main form but it doesn't fire at all, even if I put a SetFocus to the main form on exit form the edit form.

In what event should I put this:

Form_frmsubform.Refresh

Thanks y'all - and have a nice weekend!

 

[Rich]

On the Unload Event of your edit form, you'll have to get the syntax correct for referring to the subform, I would also suggest using Requery instead of Refresh.
Use the code builder to get the correct syntax for your subform

 

[rubbernilly]

Also look at the OnActivate event of the form you want to requery.

 

[Steff_DK]

Thanks for pointing me in the right direction