Call a textbox value from Subform within a Subform to Mainform.

[binbin]

Hi everyone,

Novice access user here, I have a problem calling a value from a subform within a subfrom to the mainform. I tried the suggested solutions from the searches I did but still could not figure out what is wrong. Here is my setup:

frmMain
Detail of frmMain>fsubSubform1
Footer of fsubSubform1>fsubSubform2
Detail of fsubSubform2 (txtSumOfTotal)

I want to have the value from txtSumOfTotal to put in my frmMain. Unfortunately, I have tried all the links that I have found from this site and other sites as well. I have found them to be straight forward, but somehow, I can't seem to get them to work. Here's one of the syntax from this link I'm having trouble and could not get it to work and usually get a name or error result.

Forms!frmMain!fsubSubform1.Form!fsubSubform2.Form!txtSumOfTotal

Also, I don't know if it is important but the txtSumOfTotal is based on a value from a query I made using the query of fsubSubform1.

I have attached a sample of my database. (Unfortunately my post count does not allow it yet).

For those who are wondering why not just use the usual textbox of sum in footer of subform1 then call that to a textbox in the mainform, well, that is what usually works for me, but I just seem to prefer my non-working plan as it seems to be cleaner, if only we could get it to work. Is it even possible? already spent a couple of days trying to figure it out :banghead:

 

[boblarson]

Read these and see if they help:

http://www.btabdevelopment.com/ts/ewtrhtrts

http://www.btabdevelopment.com/ts/refer2sfrms

 

[boblarson]

I have attached a sample of my database. (Unfortunately my post count does not allow it yet).

All you have to do is to run Compact and Repair first and then right-click on the file and select SEND TO > COMPRESSED FOLDER to zip it into a .zip file and then you should be able to upload it regardless of post count.

 

[binbin]

Ok, I think I saw the 2nd link before, I'm now reading the first link. Thanks, it is making sense to me. Meanwhile, I'll try attaching the database...

 

[boblarson]

Why are you using a subform for the totals when you can do it in the first subform using the form footer. Then you can use the method I show here in this sample:
http://downloads.btabdevelopment.com/Samples/subforms/SAMPLE-SubformTotalOnMainForm.zip
to display the totals.

 

[binbin]

Why are you using a subform for the totals when you can do it in the first subform using the form footer.

That is the usual way I do it, but a couple of days ago, I just got this idea of using a subform query to sum the totals of a subform, hence, my current predicament. I was just so curious if it can be done, but, it seems harder to implement, which makes it more enticing for me, weird, I know. It's just I learn more by finding out why it won't work or by trying to make it work.

I'm trying the syntax from the link you gave me, I'm trying the 4 level subform concept, customizing it to a 3 level form... still trying to make it work though.

 

[binbin]

Well, I still couldn't make it work and since I'm a bit on a deadline, I decided to go the usual way... Thanks so much boblarson for your time and help you have given, I think the answer is there in the links you gave, I just have to figure it out when I have some more spare time...