Access 2007 Won't update calculations on main form from subform

MaryC

GURU / GEEK
Local time
Yesterday, 21:53
Joined
Apr 15, 2003
Messages
13
I am using visual basic code to set values from 2 subforms w/totals to the main form using the oncurrent event. When the 1st subform has more than 7 records and a record is created in the 2nd subform, the totals go blank - any less than that number of records in the 1st subform it calculates correctly. If I use the same exact code and assign it to a command button, and click it manually once the current form is loaded, the totals appear correctly. This originally worked flawlessly in Access 2000, but my company is upgrading.:confused:
 

Users who are viewing this thread

Back
Top Bottom