Sub-Report to hide un-checked lines...

[David]

Hi,

I have a report with a sub-report.
On the sub-report I have the following data:

Product | Qty | Print (As Checkbox)

What I want to do is hide all lines in the sub-report where the Print
checkbox is UN-CHECKED and show only the lines where the checkbox is
CHECKED.

Also, if possible, I do not want any blank lines where hidden lines
are. Is it possible to remove these blank lines.
How can I get this to work ?
Thanks in advance.
David

[Salad]

David wrote:

Hi,

I have a report with a sub-report.
On the sub-report I have the following data:

Product | Qty | Print (As Checkbox)

What I want to do is hide all lines in the sub-report where the Print
checkbox is UN-CHECKED and show only the lines where the checkbox is
CHECKED.

Also, if possible, I do not want any blank lines where hidden lines
are. Is it possible to remove these blank lines.
How can I get this to work ?
Thanks in advance.
David

Lets say the forms are called MF and SF.

Let's say you have a combo box to show filtered records with the values
All, Yes, No

In the afterupdate event you could enter something like
Sub ComboPrint_AfterUpdate
Dim strFilter As STring
Select Case ComboPrint
Case "Yes"
strFilter = "([Print])
Case "No"
strFilter = "(Not [Print])
End Select
Forms!MF!SF.Form.Filter = strFilter 'empty if ALL
Forms!MF!SF.Form.FilterOn = (strFilter > "") 'True if not ALL
End Sub

[David Gordon]

Salad,

Thanks for your response.
As I explained, this is a report, not a form !

Please can you re-think your reply.
David

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Phil Stanton]

I may be missing the point, but the underlying query for the subreport
should have the line "WHERE Print = True" in it as the criteria.

HTH

Phil
"David Gordon" <da***@scene-double.co.uk> wrote in message
news:40*********************@news.frii.net...

Salad,

Thanks for your response.
As I explained, this is a report, not a form !

Please can you re-think your reply.
David

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Salad]

David Gordon wrote:

Salad,

Thanks for your response.
As I explained, this is a report, not a form !

Please can you re-think your reply.

Same concept. You simply lack the knowledge of the Reports collection
and its properties and methods. I suggest you do some study in on-line
help.

You could put the following in the OnOpen event of the report
Me.ReportName.Report.Filter = whatever
Me.ReportName.Report.FilterOn = True

Or if calling from a form
Docmd.Openreport "ReportName"
Reports!ReportName!ReportSubForm.Report.Filter = ....
Reports!ReportName!ReportSubForm.Report.FilterOn = True