View Single Post
  #2  
Old June 5th, 2010, 10:51 PM posted to microsoft.public.access
Scafidel
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

Ads