Seems like this should be easy, but I can't put the logic together....
I want to display a continuous form that shows a subset of PRODUCT records based upon a BRAND Combo Box selection at the top of the Form.
At the end of each row I want to have a Box where I can enter the amount of NEW STOCK that has been delivered.
After entering all new stock, I want to click an Update button and loop through the records of the form updating the Products with the value of the new stock that has been received and entered into the box.
Currently each row is bound and showing me the name of the product and the box at the end of each row is unbound allowing me to enter a value.
I have made a couple of unsuccessful attempts and am not sure I am doing this in the best way.
Any ideas pointers as to best,fastest way to accomplish this?