Search and Update

Hi Sir Sixthsense, actually this is part of my multipage form (Add New and Update Tab), the form attached is only the Update Tab, the combobox1 will use only on Add New Tab and will not be amended in Update Tab (hope u get what i mean despite my bad english ).


Hi Sir JapanDave,

I've run the amended file but it add new a line when i click amend button, i just want when the user search, it will update in the same line.


Also, is it possible to run the code eventhough the combobox1 enabled set to false in userform intialize event? I just want textbox4 will only enabled when userform initialize.