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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|