Solved

Subform Won't Recalculate on New Record

Posted on 2010-08-26
12
421 Views
Last Modified: 2013-11-28
Hello,

I have a subform that when the parent form opens it does all the calculations in the subform for all the records that were there when it was closed. Although when I add a new record the subform produces the #Error in those fields trying to produce the calculations. What is the best way to refresh this subform to recalculate all the fields.
0
Comment
Question by:NuclearOil
  • 6
  • 4
  • 2
12 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33530676

try,
 after saving the record
    me.requery
or
   me.recalc
0
 
LVL 18

Expert Comment

by:Cluskitt
ID: 33530743
Shouldn't it be: Me.SubformName.Requery?
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33530801
depends on where you will execute the code.
he was adding a new record in the subform, so after saving the record, or in the afterupdate event of the subform, you can just place
    me.requery
or
   me.recalc
0
 
LVL 18

Expert Comment

by:Cluskitt
ID: 33530812
Ah yes, I had missed that part. You are, of course, correct. :)
0
 

Author Comment

by:NuclearOil
ID: 33536851
Nope, neither of them seem to work, should it be in a before insert to requery the subform?
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33537049
can upload a copy of your db
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:NuclearOil
ID: 33537261
Please look at the form Order Processing.The subform is linked to Stock Number in the main form. If you create a new record and use the stock number MB-08, you'll see the #Error. If you notice on when you load the form, the calculations happen.
-Error.mdb
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33537388
please upload a working form..
the rowsource of the combo box at the main form is missing..

also include the instruction "how do you" create the new record using the subform
0
 

Author Comment

by:NuclearOil
ID: 33537928
I added the row source for you. Its just a list of customers. I haven't made the form for the inventory yet, I have just been adding records to the table InventoryNPO to test the form they use to enter new orders and check stock.
-Error.mdb
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33537956
how do you create "NEW record"?
0
 

Accepted Solution

by:
NuclearOil earned 0 total points
ID: 33549361
I just hit the start button on the bottom of the main form for the time beining. If you add the stock number MB-08, you will get that #error.
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33549562
how do you do that in the sample db that you uploaded?
there is no start button..

mind checking the sample db to reproduce the error before uploading
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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…

867 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now