Solved

Bound and Unbound Form Updates

Posted on 2013-12-22
3
845 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
  • 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

777 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