textbox value disappears when combox1 isselected

hi
I have found this code ,when com1 is selected data is found,enter name in tb8 and press save,name stays in tb8 all others clear,select
com1 again and name disappears,what I would like to happen is name stays in tb8 until exit is clicked,any pointers please,would if then statement in module checkbeforesave do it,have tried but am bit lost
cheers colin

the reason is that when you select a new item from com1 it is loading the data for that item. if you disabled the load for tb8 then you wont get all the data for that item.
if that's what you want then delete

Please Login or Register  to view this content.

from load data