Display subform total

  • Thread starter Thread starter Scafidel
  • Start date Start date
S

Scafidel

I have an Access 2007 single form with subform. The subform has a hidden
textbox that sums a record in the subform and displays in a textbox on the
form. The form textbox is blank, but becomes visable if I click on the
taskbar or open another app. If I update the subform or move to another
record, I loose it again. I've tried requery and recalc on practually every
event of the form, subform and both textboxes to no avail. What will make
this textbox stay visible?
 
Never mind; I got it. I changed the field from text to double number and
added me.recalc to the form field and it stays visible.
 
Back
Top