SubForm Delete Grid Line - Refresh Form Item

[smedvid]

I have a form with a subform. The subform has detail records for payments. On the form I have a total field that sums the subform payments. Everything works fine, when users enter a value into the subform I execute a requery (onUpdate) on the total field and it works great. the one hole is when a user deletes a record from the sub-form, I can not figure out how to requery the Total field on the form. Should be simple, but it is Friday and it has been a long week.. tia... Steve Medvid
"IT Consultant & Web Master"

 

[JoaoTL]

Try

Me.Refresh

Or if it dont work refresh from the SubForm like this

[Forms]![YourMainForm].Form.Refresh

Or use both in the SubForm

Me.Refresh
[Forms]![YourMainForm].Form.Refresh

Hope it helps
Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt

 

[smedvid]

I am using Me.Parent....Refresh and it seems to work everywhere... I'll try the other notation format. Thanks... Steve Medvid
"IT Consultant & Web Master"