after the linked field is updated on main form, the data on subform got lost

[mkiew via AccessMonster.com]

I am new to access application. I hope i can explain this clearly. I have a
main form and a subform which has the linked field strCauseNo. On the main
form, i have a textbox txtCauseNo which has the datasource strCauseNo. On
the subform i have a textbox which also has the datasource strCauseNo and a
dropdownlist which displays all the related data information from another.
Now on the main form, after i updated the value in the textbox. The subform
gets refreshed by itself (is it correct?) and all the data on the subform
are gone. I have no idea what's going on with it? But when i change the
textbox value on the main form back to the original data of strCauseNo, all
the data on the subform will be recovered. Could someone help with this
issue.

Thanks!

 

[Rick B]

please don't post duplicates in more than one group. People won't know if
it has already been answered in the other group.

 

[Pat Hartman]

Have you defined that field as the master/child link field by mistake? That
would explain why the subform refreshes and all data disappears. It
disappears because none of the child records match the parent any more.

Only the linking field should appear in both the parent and child tables.
Sounds like this isn't really the linking field at all.