Posted on 2002-03-19
i have a form with 3 textboxes across called
"Product description", "UnitPrice" and "Discount"
i have coppied these down in a control array ie
etc for each of the 3, what i would like to know is whenever i type in a product in the product description textbox it searches the "Products" table in my Access database and updates the other fields across with the appropriate information. How could i do this? and make it work for each txtbox down?
i am using the standard data control
thanks for any help!