I have a form, in which some field will come from a table. The table has three field, code, alfacode and branch. When I enter the code in text1, I want to search the code in the table ‘bcode’ and if found(), the second and third will be filled by the corresponding searched value, alfacode and branch.

I failed to do this, How to find the values from the table and how to put the values in text2 and text3?

Please help me.