Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Bound and Unbound Form Updates

Posted on 2013-12-22
3
Medium Priority
?
916 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 2000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

660 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