sub- Reports

[Alain]

Hi,

I am wondering to know if a sub report can drive a main report meaning the
main reports can only show data if a sub-report have data ?
My problem is the following, I have one tenant that is renting multiple
space in the same building, each space will have different renewal option
date, because of the one to many relation, I do not want to see duplicate
tenant info. The main report is based on the tenant info and the sub, on the
renewal option date.
I need to be able to filter the sub information based on a range of date
given thru a form used as a criteria input form.

Everytime I pass the criteria from the form to the sub-report Report_Open
event. I always get the error 2465 or 2451 depending if I use the main
report to apply filter on the sub or the sub to apply the filters.
This is the code I use:
Report![Rapport Option
Renouvellement]![sub-rptRenewalOptions].Report.FilterOn = True
Report![Rapport Option
Renouvellement]![sub-rptRenewalOptions].Report.Filter = "ExerciseDate Between
#" & varDat1 & "# And #" & varDat2 & "#"


Can anyone help me on this one.

TIA