Nested Forms--total on middle form disappears

[weigoldk]

I have three forms.

Form A has payments and it is a subform of Form B. Form A has a field in it's footer showing the total of payments. Form B displays that total (=[TblPayments Subform].Form!TotalPaid). Form B has Payees. (On one "project" there can be several payees receiving payments). At this point it works great--I see the total payments.

Form C is for the project. I want it to hold the form B for payees (which holds form A). When I get all three forms nested like this, the total field on Form B is blank--no errors, just a blank field.

Can anyone tell me what I'm missing?

 

[1DMF]

I'm a little confused over your forms set up you define it as form A being a subform of form B? so B is the master form, with a subform in it.

Why is A not the master form and B the subform, semantics I know, but just making sure I understand which is the master and which is the subform.

Anyhow,

one thing I see is you define the total by speaking direct to the form , but if it is a subform I always fully qualify this by including the master form in the defenition... like so..

=[Forms]![name_of_masterform]![TblPayments Subform].[Form].[TotalPaid]

dunno might help.





"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!

 

[weigoldk]

thanks 1DMF (I wonder what that stands for?)

Sorry for being confusing. Form C is a main form that holds Form B that holds Form A.

I did some playing last night and found that the total I wanted to see on form C had to be in the footer of form B (not JUST referenced from the footer of form A).

And yes, the name needed to be fully qualified like 1DMF is showing above. And the calculation has to come from the subform NOT from the underlying table (both mistakes I made earlier).

Maybe....One Delightful Mongoose Farmer?

 

[1DMF]

lol - err no, nice try though!

Glad you got it working and I could help in some way

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!