Problem in Form & Subform

[meLady]

Hello,

I have a form called feedback with a subform called feedback Options.

I did some counting calculation in master form "feedback" at the bottom page.

the calculation is about count the number of yes, no and null that are in the feedback Options.

the problem is that when navigate to a new form the calculation of the previous form is still in and I tried many times to find a solution but I couldn't ...

the idea is that the calculation in the new form should be empty. I have attached the jpeg files that describe the problem.

The counting process is accumulating the feedback numbers and also the values "yes", "no", and "null". it is supposed that each feedback should be seperate from each other.

For example The feedback number 1 should display only 4 records with 3 yes of Q1, 1 No of Q1 and null = 0 of Q1, while feedback number 2 should display only 2 records with 1 yes of Q1 and 1 null of Q1 and No = 0 like this (^_^)


I am only having problems all the way ....!!!??~z?

I would be more pleased if you could hlep me.

[MMcCarthy]

Hello,

I have a form called feedback with a subform called feedback Options.

I did some counting calculation in master form "feedback" at the bottom page.

the calculation is about count the number of yes, no and null that are in the feedback Options.

the problem is that when navigate to a new form the calculation of the previous form is still in and I tried many times to find a solution but I couldn't ...

the idea is that the calculation in the new form should be empty. I have attached the jpeg files that describe the problem.

The counting process is accumulating the feedback numbers and also the values "yes", "no", and "null". it is supposed that each feedback should be seperate from each other.

For example The feedback number 1 should display only 4 records with 3 yes of Q1, 1 No of Q1 and null = 0 of Q1, while feedback number 2 should display only 2 records with 1 yes of Q1 and 1 null of Q1 and No = 0 like this (^_^)


I am only having problems all the way ....!!!??~z?

I would be more pleased if you could hlep me.

Take the calculations out of the form footer and put them in the form detail section.

[meLady]

Take the calculations out of the form footer and put them in the form detail section.

I did and It did not work ... it concerns the Refer Object Expressions (Connecting the Primary Key and Foreign Key)!

[MMcCarthy]

I did and It did not work ... it concerns the Refer Object Expressions (Connecting the Primary Key and Foreign Key)!

You can't have it in the form footer as this will work over all the records in the form.

What is the calculation in the textbox?

[meLady]

You can't have it in the form footer as this will work over all the records in the form.

What is the calculation in the textbox?

Hello mmccarthy,

Thanks for your concern, the problem has been solved ... my friend has solved the problem ... as I said ... it concerned something called "Refer Object Expressions" where my friend has add only this expression to link the data in the master form with the detail form ("Id=" & [id]) ... and it worked successfully (^_^)