I am trying to find out if there is a way to add search function into the Form where user will type one filed and background code can populate all the fields.
The search field' source will be "productcode". My best guess is that I will add a button "search". When user presses, it will hide all the fields except "productcode". I will use Field.visible = F lase to do this. Beside I can add another button GO which will be Visible False at the begining but become visible true as the user click "Serach" button. This way user will see productcode field and GO button.
When user type item code into the feild (productcode) and pressed GO button, the background code will search that record , all the feilds will become visible, simultanously getting populated at the same time.
Can anybody help me for the code which can search and asign proper value to each feild.
Thank You.
The search field' source will be "productcode". My best guess is that I will add a button "search". When user presses, it will hide all the fields except "productcode". I will use Field.visible = F lase to do this. Beside I can add another button GO which will be Visible False at the begining but become visible true as the user click "Serach" button. This way user will see productcode field and GO button.
When user type item code into the feild (productcode) and pressed GO button, the background code will search that record , all the feilds will become visible, simultanously getting populated at the same time.
Can anybody help me for the code which can search and asign proper value to each feild.
Thank You.
