dsum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

binny - 06 Apr 2008 10:41 GMT

I'm using Dsum in a control on a form to total records in a table. It's
working but not until I close the form and reopen it.
What am I missing?
the Dsum is in the control source should it be in the update event?

Signature

binny

Reply to this Message

Al Campagna - 06 Apr 2008 14:35 GMT

Binny,
Your DSum probably relies on a value that you eneter into the record.
Until the record has been updated to the table, the calculation doesn't have
the values to operate upon.
When all the elements of the calculation are entered, do a Refresh...
and the calculation should work.
By closing and reopening the form you are forcing an Update. The
Refresh will accomplish the same thing.

Signature

hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

> I'm using Dsum in a control on a form to total records in a table. It's
> working but not until I close the form and reopen it.
> What am I missing?
> the Dsum is in the control source should it be in the update event?

Reply to this Message

binny - 06 Apr 2008 22:18 GMT

thanks Al about a hour of head scratching brought me to the same conclusion I
labled the refesh control button "calulate total" and evey thing now looks
and works fine.

Signature

binny

> Binny,
> Your DSum probably relies on a value that you eneter into the record.
[quoted text clipped - 8 lines]
> > What am I missing?
> > the Dsum is in the control source should it be in the update event?

Reply to this Message