Display subform total

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?
 
S

Scafidel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top