Dear Friends,
I need a help from all of you. That is, I need to write a search method to search data once you click on the Search button. Ok I'll explain the senario as below.
Assume that once you click on the Search button it will be dropped down the code list from a combo box in the form. Then, once you select the perticular code from the dropped down list, and the combo box will hide and another text box appear there diplaying the code that you have already selected from the combo box. At the same time it should search for the perticular recordset from the table in the DB and display data in the form. Ex. If you select Code, then it will be able to find the description for that and display both Code and description in the form.
Hope you will guide me.
Tnx.