Is there any way that i can updated the linked field on the main form, but
the subform won't get updated automatically.
Thanks!
No; that's why it's a link. If you change the link on the mainform,
it's designed to reflect that change on the subform!
Could you explain what you're trying to accomplish? If you have a
Subform linked to a particular value of a main form field, what do you
want to see on the subform if that value changes?
John W. Vinson[MVP]