"Rosy" <kr****@portlite.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I have a sub-form(company name & address) that is connected to my
contact listing. When I change the contact, it doesn't update the
subform until I close the main form or refresh. Is there a way to make
it update when I tab out of that field?
Could you clarify? I'm not sure I understand what you are doing and
expecting.
Does your Subform Control use the LinkMasterFields and LinkChildFields to
synchronize with the Record in the main Form? Do you mean when you move to
another Record in the main Form that the Subform is no longer synchronized?
If you use the LinkMasterFields and LinkChildFields, then it should
synchronize.
If you are displaying the same data in the main Form and the Form embedded
in the Subform control, and change some data in the main Form, that is a
different situation. If so, give additional details and perhaps someone can
assist.
Larry Linson
Microsoft Access MVP