A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How refer to cols in main report from sub report



 
 
Thread Tools Display Modes
  #1  
Old May 24th, 2004, 11:06 PM
David
external usenet poster
 
Posts: n/a
Default How refer to cols in main report from sub report

I have a main report containing 3 subreports. The only reason I made these subreports is because depending on the value of one column in my main report I need to bypass one or more subreports. What is the correct way to do this? My Access book gives just a passing mention to subreports. I have a test in the open for each subreport for the value of the main report column and if I need to bypass the subreport, I close the subreport. Is this correct? In any case, my column test is failing. It cant find the value of the column in my main report query. How do I refer to it?
  #2  
Old May 25th, 2004, 01:56 PM
external usenet poster
 
Posts: n/a
Default How refer to cols in main report from sub report

A column of a report (unlike that of a listbox) is a
section and has no value, you need to refer to the value
of a control such as a textbox in the column.

If your report consists of a listbox followed by three
subreports, then refer to the[listbox.name].[column
(x,y)].[value] where x=column number with the starting
column =0 and y=row number.

-----Original Message-----
I have a main report containing 3 subreports. The only

reason I made these subreports is because depending on
the value of one column in my main report I need to
bypass one or more subreports. What is the correct way to
do this? My Access book gives just a passing mention to
subreports. I have a test in the open for each subreport
for the value of the main report column and if I need to
bypass the subreport, I close the subreport. Is this
correct? In any case, my column test is failing. It cant
find the value of the column in my main report query. How
do I refer to it?
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.