dsum

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?
--
binny

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.
--
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."

"binny" wrote in message
...
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?
--
binny

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.
--
binny


"Al Campagna" wrote:

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.
--
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."

"binny" wrote in message
...
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?
--
binny