How refer to cols in main report from sub report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
Click to expand...
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?
 
Back
Top