Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Subform Won't Recalculate on New Record

Posted on 2010-08-26
12
Medium Priority
?
466 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33537049
can upload a copy of your db
0
 

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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

783 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