Solved

Bound and Unbound Form Updates

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

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

Suggested Solutions

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

739 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