Solved

Bound and Unbound Form Updates

Posted on 2013-12-22
3
899 Views
Last Modified: 2013-12-23
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!
0
Comment
Question by:GenesisTech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 39735629
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.

The key is using a bound field on a continuous mode form  to enter the value for each product. An unbound control will hold the same value for every report.

You will need to use a bound control to enter the amount of NEW STOCK for each item.

I normally use a temp/work table to handle this. After the user makes a Combo Box selection at the top of the Form  I use the after update event to delete the records from the temp/work table and append the desired records. into the temp/work table. This table would also include a field for the "NEW STOCK " with a default value of Zero (0).
0
 

Author Closing Comment

by:GenesisTech
ID: 39737079
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!
0
 
LVL 21
ID: 39737477
You're welcome.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question