Display Subform Record sum on main form (1 Viewer)

[sigma788]

Hi all, I have applied different methods to show subform sum on main form. but it gives me an error.
either i am doing something wrong or my access version 2003 is creating problem.
i have attached the database.
Many thanks for all any help,

 

[vbaInet]

Does the Sum show correctly on the subform?

Copy and paste what you wrote in the textbox that is on the main form.

 

[sigma788]

=[mysub].[Form]![TotalSum]
where mysub is the name of subform and TotalSum is the textbox on mysub with controlsource =nz(Sum([Total]))

 

[sigma788]

the subform has datasheet view and gets populated by unbound textboxes on mainform.
that is why(i think) it does'nt get sumed on subform and gives error.

any ideas how to get round this problem.

 

[stopher]

There's something wrong with your forms - I think they've got themselves in a pickle.

I suggest you build your main form and subform from scratch. You should be able to use Dataview.

Note that the reference to the subform control will be:

=[Forms]![frm]![mysub].[Form]![TotalSum]

Leave the filtering and any code until you've got this fixed.

Chris

 

[sigma788]

i tried another option
saved the subform recordsource as query, than sumed it and used a command button on mainform to open that query. it worked and shows the correct sum now (strange...)

 

[vbaInet]

It's more like there's a problem with your table. It has experienced some form of corruption. Create a brand new table and link it back to your other tables and form. Also remember to give it a Primary Key as you currently don't have one.

I will advise that you also create brand new tables for your other tables afterwhich you can copy and paste from the old to the new.