OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   General Discussion (http://www.officefrustration.com/forumdisplay.php?f=22)
-   -   Display subform total (http://www.officefrustration.com/showthread.php?t=1119275)

Scafidel[_3_] June 3rd, 2010 07:32 PM

Display subform total
 
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

Scafidel June 5th, 2010 10:51 PM

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



All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
OfficeFrustration.com