Ok here my idea, i got a listbox and textbox in one form and what i want to do is when user click item in listbox, the item will transfer to textbox. I already achive this using vba code but i failed to get is to make the item in listbox is dissapear when the record available (so number of item will be decrease). It is possible to make item in listbox dissapear? Plz tell me how... Tq