Need search button and update button vba codes

Hi,

I have a userform for data entry.

I am able to make codes for Add ( Add entry to database), clear ( Clear userform ) , Cancel (Exit userform).

I have some more buttons and functions to be assigned to them but not able to write code .It will be glad if anyone can help.

Need codes for :

1) Have search box which searches Mat id in the complete database and returns value in the search result listbox. When we click on the result in listbox , the userform values are filled with the values that the mat id has . Then if user wishes he can update teh details for that mat id , and click on update button . the data is updated in the database. Or he can delete the entry from database by clicking on delete button.

2) Have arrows which will navigate through database ( need code for that ) .


Thanks in advanced
Mayur patil

USERFORM.xlsm

Cross posted: http://www.ozgrid.com/forum/showthread.php?t=178405

Look in help for "Search function", this may be of some use.