Requery mulptiple forms Access 2007

[shanna_bears]

I have reviewed a lot of the blogs of requerying multiple subforms and have
tried them and have had no luck.

I am designing a db for a trucker that wants to keep track of trips along
with mileage and revenue.

My main form just assigns the trip #. The 2nd subform is for the data entry
of the trips including desitnation, miles and revenue. There could be many
in one trip so that is why I did it this way. The 3rd subform is to just
summarize the miles and revenue. When the miles and revenue is added, the
only way it updates on the third form is if I click on the form and hit the
"refresh" button. I have also just tried to make a text box on the main form.
I can get it to read from the first entry, but when I tell it to sum, it just
gives me an error. Any recommendations? I fear I am making this more
difficult than it needs to be. I was pretty comfortable with 2003 but
recently converted to 2007 and I am stumped.

 

[Mike Painter]

I have reviewed a lot of the blogs of requerying multiple subforms
and have tried them and have had no luck.

I am designing a db for a trucker that wants to keep track of trips
along with mileage and revenue.

My main form just assigns the trip #. The 2nd subform is for the
data entry of the trips including desitnation, miles and revenue.
There could be many in one trip so that is why I did it this way.
The 3rd subform is to just summarize the miles and revenue. When the
miles and revenue is added, the only way it updates on the third form
is if I click on the form and hit the "refresh" button. I have also
just tried to make a text box on the main form. I can get it to read
from the first entry, but when I tell it to sum, it just gives me an
error. Any recommendations? I fear I am making this more difficult
than it needs to be. I was pretty comfortable with 2003 but recently
converted to 2007 and I am stumped.

Assuming you have everything in a trusted locations there should be little
problems.
Miles and revenues should be calculated.
I would put a summation of those values on the subform and thern refer to
them in fields on the main form.
http://www.databasedev.co.uk/subform-total.html has a detailed example

 

[CJ]

I have a similar setup on my form.

You might want to try Me.Parent.Requery in the AfterUpdate event
of Miles and/or Revenue.

HTH

 

[Troy]

You may also want to run a requery command on the subforms. This basically
will run the query behind the subform again so that the updated data is shown.

http://access-databases.com/