Link text Box to Combobox in Userform and autoupdate database

@john

Ya.. i checked it again, its working, i was trying to be overtly smart by using a check box..!:P
thanks for the help man..!

and i am not able to edit the first post hence cannot make it solved. I dunno why is that happening. Will mail the forum regulators regarding this..!
thanks newes.