P
Patrick Stubbin
I have a form with three embedded subforms, on the first subform is a
separate subform that calculates a value based on the data within the third
embedded subform. What I need is the value generated in the first separate
subform (located in the first embedded subform) to be updated everytime data
in the third embedded subform is changed.
The data in the separate subform is a totalising query and should change if
i change data in the underlying thrid embedded subform, the only time it
does cahnge is when i close all the sub forms and re open.
Please help...... i have tried various requery statements and none seem to
work
separate subform that calculates a value based on the data within the third
embedded subform. What I need is the value generated in the first separate
subform (located in the first embedded subform) to be updated everytime data
in the third embedded subform is changed.
The data in the separate subform is a totalising query and should change if
i change data in the underlying thrid embedded subform, the only time it
does cahnge is when i close all the sub forms and re open.
Please help...... i have tried various requery statements and none seem to
work