Hey guys,
Just undetaken a project for work using access 2007
Im not very literate with 2007, i knew a little bit of 2003 but not very advanced.
Basically i have a combo box for the products which is link to my Product_tbl and the field Product_Name. This then obviously shows all the products in the database.
I also have a brand new text box that hasnt been modified at all yet, BUT it will be used to show the quantity of the product selected by the combo box.
Ok so what i want to achieve and need help with:
Basically when i select a product from my combo box, i want the quantity to show in the new text box automatically. thats the first problem i need to overcome.
The next problem is once i have the first part up and running smoothly i want to be able to change the quantity up and down as people rent out the product and save it back into the table.
Thanks in advance!!
Just undetaken a project for work using access 2007
Im not very literate with 2007, i knew a little bit of 2003 but not very advanced.
Basically i have a combo box for the products which is link to my Product_tbl and the field Product_Name. This then obviously shows all the products in the database.
I also have a brand new text box that hasnt been modified at all yet, BUT it will be used to show the quantity of the product selected by the combo box.
Ok so what i want to achieve and need help with:
Basically when i select a product from my combo box, i want the quantity to show in the new text box automatically. thats the first problem i need to overcome.
The next problem is once i have the first part up and running smoothly i want to be able to change the quantity up and down as people rent out the product and save it back into the table.
Thanks in advance!!