Avatar of GenesisTech
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!
Microsoft Access

Avatar of undefined
Last Comment
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
GenesisTech

TheHiTechCoach -

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!
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

You're welcome.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes