didn't get ur idea quite rightly. I think u should go through my 1st post again to understand what i m asking...

I need a little help from you all. I am making a FMS Project with Oracle @ back end and VB as frontend.

I have a listbox with 3 options - Term I,II & III. Now, I want that when person chooses term I and clicks on NEXT BUTTON, then a new record should be added in the table (which I have done succesfully with ADODB) but when he chooses Term II or III, the database should be searched by admission no. and then the matching record...