Subform Requery

R

reterrig

I have one form with two subforms SubA & SubB.
In the SubA I have a control box CtrlSubA that is updated from a control box
CtrlSubB in the SubB .
The CtrlSubA is updated when I change data in various fields (SubB auto
requerying) but is not updated when I go from one record to the other using
the Navigation Buttons of the SubA. The CtrSubA of the next records shows the
amount of the previous one. I have to click on a command button to requery
the SubA so to recalculate in combination with CtrlSubB and to show the
correfct amount.
Same problems appears when I try to print a relevant Report that seeks data
from the CtrlSubA. It prints the same amount for all the records that are
appeared on the screen prior the printing.

Any Idea which way I can solve this problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top