Calculations on Main form do not reflect calculations on subform

[Lou_Reed]

A subform/subreport is created by placing a subform/subreport container control on a form/report. The container has a SourceObject property. This can reference a table, query, form, report. The container has Master/Child Links properties that will synchronize related records from main form and SourceObject.

Do you have a link for this that elaborates on this topic?


Respectfully,



Lou Reed

[June7]

Search Access Help or web. Try these:

http://fisher.osu.edu/~muhanna.1/837...s/subforms.pdf

https://support.office.com/en-us/art...8-C266FE084102

[Lou_Reed]

Here is my current version of Ceil Inn4.accdb. Everything is fine except for the calculation of
Internet Use on the main form.

That error also affects Net Pay calculation below it, because whatever is calculated in Internet Use is used in
the Net Pay.

I have attached the compacted Ceil Inn4. I cannot find the error in the calculation of Internet Use.

Any help is appreciated. Thanks in advance.

Respectfully,


Lou Reed

[June7]

Name of textbox on subform is: txtsbfTotalInternetFee

The expression in textbox on main form is: =[sbfCustomerRoomUse].[Form]![txtTotalInternetFee]

Note that sbf in the textbox name is not in the expression reference. Fix the expression reference: =[sbfCustomerRoomUse].[Form]![txtsbfTotalInternetFee]

Then the names of textboxes on main form are: txtPhoneUse, txtRateTotal, txtInternetUse, txtNetPay

The expression in txtNetPay: =Nz([txtPhoneUse])+Nz([txTotaltInternetFee])+Nz([txtRateTotal])

The expression in txtNetPay should be: =Nz([txtPhoneUse])+Nz([txtInternetUse])+Nz([txtRateTotal])

Access intellisense popups should help build expression with correct references as you type the expression.

[Lou_Reed]

Now wait a second. I am not that bad. I knew about and corrected these errors. There should have not been an sbf anywhere. I gave that up.

Also, I know that calculation for txtNetPay should not have a Total in it anywhere at all.

I know that I changed these. It just that sometimes they appear to not remain changed. I cannot explain that.

Yes , I periodically save everything.

What is going on?

R,


Lou Reed

[June7]

Don't know, but that's the db you posted. I made those edits and saved the form and it works.

[Lou_Reed]

Okay, I see the situation more clearly.

When you say textbox on subform is : txtsbfTotalInternetFee you are speaking about the textbox in the Form footer below the detail section. I am not sure why there are two textbox for internet charges, but there are. It seems redundant.

But that is where the textbox with the sbf in the title resides in the form footer textbox. Now I see what you are speaking about.

There is something very confusing here. These textboxes are on the detail section and in the form footer. Please note there is a subform textbox in the detail section with
the same parameters. Of course, the exact same parameters cannot be used. The would send up and error.

Could this tutorial again be in error?


Thanks in advance.

Respectfully,

Lou Reed

[June7]

The textboxes in the subform Detail section should just be bound to the fields, not have Sum() expressions. Earlier posted versions of db did this correctly. You edited the Detail section textboxes instead of the Footer textboxes.

[Lou_Reed]

I have written as =RateApplied,
=PhoneUse and
=InternetFee.

Is this correct?

Should I leave out the = sign in each text box?

Thanks in advance.


Respectfully,


Lou Reed

[June7]

Do not use = sign when binding to field.

[Lou_Reed]

I am including the modified database. It still is not outputting two
values in the textboxes. They are for Phone Use, which outputs a blank
screen, and InternetUse, which outputs #Error.

I have checked the preceding calculations and have not found the error.

I hope that someone else can.

Also, when I put in the boxes at the bottom of the subform say InternetFee, MS Access 2010 adds
the =[] around it When I go back and check it all I see is "=[InternetFee]". So it is done for me.

I believe the final value Net Pay will be out when these two textboxes are fixed.

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[Lou_Reed]

Okay, I got Internet Use to print out. That one was easy. I just selected
fixed for format and it worked.

Now if just can get Phone Use to display.

Thanks in advance.

Respectfully,


Lou reed

[June7]

The expression on main form is: =[sbfCustomerRoomUse].[Form]![txtTotalPhoneUse]

Again, textbox in subform Footer is named: txtPhoneUse. Textboxes in subform Detail section are named: txtTotalPhoneUse, txtTotalInternetFee

These names are on wrong textboxes.

[Lou_Reed]

Okay, I will try it. I think that you are right. It just seems things would be easier if we
had all variable defined and listed like when you run a c or Fortran program.

Thanks very much.

Respectfully,

Lou Reed

[June7]

Not sure what naming controls has to do with defining variables in a program.

Access does have intellisense popup tips as you type expression. Aren't you seeing them? There is also the expression builder dialog (which I actually never use).