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 "The setting you entered isn't valid fot this property." 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>
<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 "The setting you entered isn't valid fot this property." 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>