'Lord Help Me' Project

On Mon, 16 Oct 2006 06:08:02 -0700, laura reid
wrote:

Yes, requery is the way I went. However since the user is never permitted to
change any fields in the main form, I ended up placeing a button on the main
form footer and after all the changes in the various subforms are made, the
user then presses the button to get a new total.

Just FWIW, you can put a line

Parent.Requery

or possibly also or instead

Parent.Recalc

in the AfterUpdate event of each Subform which contributes to the form
total; this will make the button press unnecessary.

John W. Vinson[MVP]

You people ROCK! Thanks so much, I'll give this a try at work tomorrow.
Should you get bored here, I've posted a request for help with a query I want
to design in the query newsgroup

with much gratitude,
Laura

"John Vinson" wrote:

On Mon, 16 Oct 2006 06:08:02 -0700, laura reid
wrote:

Yes, requery is the way I went. However since the user is never permitted to
change any fields in the main form, I ended up placeing a button on the main
form footer and after all the changes in the various subforms are made, the
user then presses the button to get a new total.

Just FWIW, you can put a line

Parent.Requery

or possibly also or instead

Parent.Recalc

in the AfterUpdate event of each Subform which contributes to the form
total; this will make the button press unnecessary.

John W. Vinson[MVP]

Hi Laura,

as an add-on to what John said, if you are using SUM in a control, it
acts on SAVED records... ever notice the pencil icon in the gray record
selector area to the left of the record? That means that data is not
yet written... a solid right-pointed triangle signifies no changes have
been made to the record since it was saved

if a field is used in a calculation, on the AfterUpdate event of its
control:

me.dirty = false

will save the record

if you are moving out of a subform, you might put this on the OnExit
event of the subform control:

if me.dirty then me.dirty = false

btw, my attention was drawn to this thread because of the excellence
that BruceM has with words...

Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



laura reid wrote:
You people ROCK! Thanks so much, I'll give this a try at work tomorrow.
Should you get bored here, I've posted a request for help with a query I want
to design in the query newsgroup

with much gratitude,
Laura

"John Vinson" wrote:

On Mon, 16 Oct 2006 06:08:02 -0700, laura reid
wrote:

Yes, requery is the way I went. However since the user is never permitted to
change any fields in the main form, I ended up placeing a button on the main
form footer and after all the changes in the various subforms are made, the
user then presses the button to get a new total.
Just FWIW, you can put a line

Parent.Requery

or possibly also or instead

Parent.Recalc

in the AfterUpdate event of each Subform which contributes to the form
total; this will make the button press unnecessary.

John W. Vinson[MVP]