Hide Requey Action

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 01 May 2005 13:26 GMT

I have a Main Form with a Subform on it. The Main form has a Calculated
Unbound Field based on the Sum of the Subform. Whenever I delete a
record from the Subform you can see the field on the Main Form refresh
itself Any way to hide this action? I'm using code.
Thanks
DS

Reply to this Message

Dirk Goldgar - 01 May 2005 23:35 GMT

> I have a Main Form with a Subform on it. The Main form has a
> Calculated Unbound Field based on the Sum of the Subform. Whenever I
> delete a record from the Subform you can see the field on the Main
> Form refresh itself Any way to hide this action? I'm using code.

I'm not sure what you want to have happen. Do you or do you not want
the calculated control on the main form to show the updated value? If
you want it to show the updated value, it's got to be refreshed somehow,
so what do you want to see or not see? If you don't want it to be
updated automatically, you'll probably have to make completely unbound
and use code to calculate the value and stick it into the control.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message