Hi,
I have in my database a form that is called Product. (with productid,productname, product description,unit price,in stock etc...). Everytime i want to see all the information from one product, i have to use the navigation bar (record selector)to select the product.It takes a lot of time to go through all the products to get the one i want.
What i want is to make the box 'productname' into a combobox so that i can select from it, and to see all the information from that particular productname too. But i don't the query or the expression for it.
Can anybody help me!!!!
Thx in advance
I have in my database a form that is called Product. (with productid,productname, product description,unit price,in stock etc...). Everytime i want to see all the information from one product, i have to use the navigation bar (record selector)to select the product.It takes a lot of time to go through all the products to get the one i want.
What i want is to make the box 'productname' into a combobox so that i can select from it, and to see all the information from that particular productname too. But i don't the query or the expression for it.
Can anybody help me!!!!
Thx in advance