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

  • Thread starter Thread starter mkiew via AccessMonster.com
  • Start date Start date
M

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
table. 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!
 
please don't post duplicates in more than one group. People won't know if
it has already been answered in the other group.
 
Back
Top