View Single Post
Old June 5th, 2010, 10:51 PM posted to microsoft.public.access
external usenet poster
Posts: 35
Default Display subform total

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.
Lafayette, LA

"Scafidel" wrote:

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?
Lafayette, LA