Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I can not use filter in the subreport

Status
Not open for further replies.

seaport

MIS
Jan 5, 2000
923
US
I ran into a problem when designing a report, which has no recordsource but includes seven subreports. I also put the following code in each of the subreport.<br>
<br>
Private Sub Report_Open(Cancel As Integer)<br>
Me.FilterOn = True<br>
Me.Filter=PublicVariable<br>
End Sub<br>
<br>
Each subreport ran perfectly if it is not called by the main report. However, if i can the main report, I got the warning message as &quot;The setting you entered isn't valid fot this property.&quot; When I went to the debug mode, I found out the code stop at both lines in Report_Open event procedure.<br>
<br>
It seems that the only reason is I can not set the filter to a subreport on the runtime. It is unreasonable if this is true.<br>
<br>

 
can you paste those lines here<br>
and which event there are in. <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top