469,934 Members | 2,642 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Problem in Form & Subform

meLady
27
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.
Attached Images
File Type: jpg Feedback number 1.JPG (73.1 KB, 210 views)
File Type: jpg Feedback number 2.JPG (67.7 KB, 203 views)
Apr 20 '07 #1
4 1680
MMcCarthy
14,534 Expert Mod 8TB
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.
Apr 21 '07 #2
meLady
27
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)!
Apr 21 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
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?
Apr 21 '07 #4
meLady
27
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 (^_^)
Apr 23 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by DS | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.