Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access TechHelp    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Transfer Data to Subform
James Hopkins 
     
3 years ago
Hey Richard and the Guys, I have an Inventory Tracking Information Form that i can "Add, Subtract, or Reset Inventory Level". The problem I am having is trying to add the Data from the Single Form that is using to for "Add, Subtract, or Reset Inventory Level". Transfer and Add the Data the Continuous Subform on the Main Single Form. the Continuous Form would not add the New Data to the Table and display in the Continuous Form, it just changes the current Data in the Table.
Kevin Robertson  @Reply  
          
3 years ago
Did you go to a new record first?
James Hopkins OP  @Reply  
     
3 years ago
Here's my setup :
James Hopkins OP  @Reply  
     
3 years ago

James Hopkins OP  @Reply  
     
3 years ago

James Hopkins OP  @Reply  
     
3 years ago

James Hopkins OP  @Reply  
     
3 years ago

James Hopkins OP  @Reply  
     
3 years ago
Here's the Code I'm using:

Private Sub BtnSaveInventoryLevel_Click()

    If IsNull(TransactionQty) Then
        DoCmd.GoToControl "TransactionQty"
        Exit Sub
    End If
            
    DoCmd.GoToRecord , , acNewRec
    Forms!TrackedInventoryInformationF!TrackedInventoryUsageSubF.Form!TransactionDate = TransactionDate
    Forms!TrackedInventoryInformationF!TrackedInventoryUsageSubF.Form!UsageAmount = TransactionQty
    Forms!TrackedInventoryInformationF!TrackedInventoryUsageSubF.Form!TransactionType = TransactionType
    
    DoCmd.Close acForm, Me.Name, acSaveYes
  
End Sub
Kevin Robertson  @Reply  
          
3 years ago
You need to set the focus to your Subform object before going to a new record.

TrackedInventoryUsageSubF.SetFocus
DoCmd.GoToRecord , , acNewRec


Make sure Allow Additions is set to Yes.
If you need Allow Addition to be No then turn them on before the code, then turn them on again after.

Forms!TrackedInventoryInformationF!TrackedInventoryUsageSubF.Form.AllowAdditions = True
'
'
'
Forms!TrackedInventoryInformationF!TrackedInventoryUsageSubF.Form.AllowAdditions = False
James Hopkins OP  @Reply  
     
3 years ago
Hey, the Data on the Single Form that I am trying to Add to Continuous Form will not input into the Continuous Subform on the Main Single Form. I can not get the Form the Add New Records into the Continuous Form. It just changes the Data in the Table, not Add the new Record to the Table.
James Hopkins OP  @Reply  
     
3 years ago
"Add Additions" is set to Yes
"Data Entry" is set to No

On all Forms
James Hopkins OP  @Reply  
     
3 years ago
I may have to Insert the Data from the Single Form, that's not bound to nothing, into the Table instead of the Continuous Subform.
James Hopkins OP  @Reply  
     
3 years ago
Hey guys, how can fix problem of, the Data on the "Add, Subtract, or Reset Inventory Level" Single Forms that I am using to Add the Data to "Usage Continuous Subform". The Form will not input into the "Usage Continuous Subform" on the Main "Track Inventory" Single Form. I can not get the Form the Add New Records into the Continuous Form. When transfering the the "Usage Continuous Subform", it just changes the Data in the Table and not "Add the new Record" to the Table or Continuous Form'
Scott Axton  @Reply  
        
3 years ago
James
You may want to go watch the Invoicing videos. (or re-watch if you already have)
Especially the extended cut.

Why? If you think about it, receiving inventory is pretty much just the reverse of what you are doing in adding an item to an order. For an order you are taking items out of stock.  
The same concept could be used to bring in inventory - Add items to your stock level.

Other videos that may be of help:
Inventory
Manage Rental Inventory
James Hopkins OP  @Reply  
     
3 years ago
Hey, Scott, I have watched the Tech Help Videos several times to double check to see if I was missing something. I have the same setup in my "Invoice, Estimate, Contract, and Purchase Order Detail Subforms" with using the Combo Box and a Button to Insert the Data into the Continuous Form. I haven't get it to work with an Standalone Single Form to Insert into the Continuous Subform.
James Hopkins OP  @Reply  
     
3 years ago
I also tried what Kevin was saying:

TrackedInventoryUsageSubF.SetFocus
DoCmd.GoToRecord , , acNewRec

Make sure Allow Additions is set to Yes.
If you need Allow Addition to be No then turn them on before the code, then turn them on again after.

Forms!TrackedInventoryInformationF!TrackedInventoryUsageSubF.Form.AllowAdditions = True
'
'
'
Forms!TrackedInventoryInformationF!TrackedInventoryUsageSubF.Form.AllowAdditions = False
James Hopkins OP  @Reply  
     
3 years ago

James Hopkins OP  @Reply  
     
3 years ago

James Hopkins OP  @Reply  
     
3 years ago

Kevin Robertson  @Reply  
          
3 years ago
Have you tried using an INSERT INTO statement? Then Requery the Subform.
Scott Axton  @Reply  
        
3 years ago
James -
Keep in mind that a form is just a way of interacting with the fields and data in a table (generally).
Rather that trying to put something into a form, you are entering or modifying data into a field. Then, if your other form is open in the background, your events just tell Access, "Hey I made a change. Go out and get the new information and load it into that other form."

I know it isn't exactly what you are trying to do here but go watch the Event Enrollment videos.  In it Richard shows how when a payment is made the totals are updated in the subform of the EventF and also in the EventListF.  The Lego pieces may look different but the concept is the same.  It is just how you put the pieces together.

James Hopkins OP  @Reply  
     
3 years ago
Scott and Kevin, y'all guys are awesome... I was thinking about it and wrong. Tieing the Single Form the table and Requerying the Surform, gets exactly I was looking for to do. Thank again for your time and help.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access TechHelp.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/14/2026 4:30:05 AM. PLT: 1s