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

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