GenesisTech
asked on
Bound and Unbound Form Updates
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?
Thanks!
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?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
ASKER
You da man! I figured it out about 15 minutes after I posted this question. I realized that I could make a temp table, that included my "unbound" fields (so that they would be bound) then I could load and unload the temp table as needed based upon user input.
The write a query to update the production table based upon values entered into my temp table.
Works like a charm!
I am giving you the points for taking the time to answer me and for confirming this is the way to go.
Thanks again!