Refresh Main Form after UpDate of each record on subform

[ImStuk]

I have a form that has a Command Button to refresh the forms data. What I would like it to do is refresh each time I add a record to the subform. I thought maybe on the subforms After_Update event. What would be the best way to approach this? I thank you in advance for any input.

 

[jbento]

I have been trying to figure this problem out as well.

I have a work-a-round where I close the main form and just open it back up.

I use the following:
DoCmd.Close acForm, "frm_test"
DoCmd.OpenForm "frm_test", acNormal, "", "", , acNormal

I do that and it refreshes. I know it might not be the best way, but I figure something else out that's what I do.

Hope that helps,

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[sfm6s524]

One method I've used is the Timer event on the main form:

If Me.TimerInterval = 5 Then ' 5 is just arbitrary.
Me.Requery
Me.TimerInterval = 0
End If

Then on the subform After_Update event:

Parent.TimerInterval = 5