Requery Total on Parent

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

Hi Groupies

I have a form that contains ten subforms on tab pages. Each tab is a
different category of equipment needed for a job. I have an item extension
(qty *cost) for each record and also a total for each category.

My problem is that I need the total for the overall job to update properly.

The job total is in the Parent form footer and it does calculate correctly
but the value does not show up until I click in the calculated field. I have
tried forcing a requery using the on change event of the item extension and
the category total but no luck. I also need this item to reflect changes as
soon as an item extension changes.

Any ideas??

Thanks
CJ
 
The Change event should be ok. (Or AfterUpdate, if you want to wait
until the user has finished typing the new value & then goes to exit
the field.)

Try: Me.Recalc instead of Requery.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Back
Top