UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Retrieve Data From Subreport, Access 2016    
 
   
rizmin
post Jul 15 2019, 12:04 PM
Post#1



Posts: 182
Joined: 10-August 17



Hi All,

Is it possible to get the below expression data from the Subreport, I have used the following expression in order to retrieve the data from the subreport to the main report but it is showing errors. Are there any other alternative methods to get this subreport textbox data?

Note: Please see the attached item, I need the Text31 data to the yellow highlighted textbox.

CODE
[Reports]![qryTanksDailyProduction subreport]![Text31]


Thanks
Attached File(s)
Attached File  1.PNG ( 27.58K )Number of downloads: 2
 
Go to the top of the page
 
theDBguy
post Jul 15 2019, 12:19 PM
Post#2


Access Wiki and Forums Moderator
Posts: 76,081
Joined: 19-June 07
From: SunnySandyEggo


Hi. It should be possible as long as the syntax is correct, I think. But if you're asking for an alternative method, then maybe you could investigate if you could use TempVars.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
rizmin
post Jul 15 2019, 12:30 PM
Post#3



Posts: 182
Joined: 10-August 17



Yes, DBGuy,

The syntax was wrong: below is the correct one I have used. Thanks for your response.

CODE
=[qryTanksDailyProduction subreport].[Report].[text31]
Go to the top of the page
 
theDBguy
post Jul 15 2019, 12:34 PM
Post#4


Access Wiki and Forums Moderator
Posts: 76,081
Joined: 19-June 07
From: SunnySandyEggo


Congratulations! Glad to hear you got it sorted out.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    24th August 2019 - 08:19 PM