calculate in subform didnt show up.

[AMRI YULIANDI]

why this calculate query didnt show up? i must open other folder then back to access.. anyone can help? without using alt+tab or else.. thx

[June7]

I don't understand what you are trying to do. This is form/subform arrangement? You want a subform to sum records of main form? that would be highly unusual.

[AMRI YULIANDI]

hi june, thanks for replying. The main problem is the textfield sum already work, but i need (eg. alt + tab lost focus from my window) to make result showing in textfield.

[June7]

Sorry, don't understand any of that. What exactly are you trying to show in the subform?

[AMRI YULIANDI]

there 1st picture is when im running the access, but the textbox didnt direct calculate.. but when im open other folder then back to access the textbox work perfectly.. the question why when 1st running its didnt show the calculate result? is there any setting im missing? thx

[June7]

I don't understand the form/subform structure. Data is on main form and you want a sum on subform? Or is data in subform and you want sum on main form?

If you want to provide db for analysis, follow instructions at bottom of my post.