set selection formula for subreport in Crystal reports using visual basic 6.0

[freewilly]

Hi s

You tell the Crystel report which subreport you want to change and simply make the changes to that sub report as if it were the main report. In the code below I set the SubreportToChange property to the correct sub report. I then set its selection formula, and then set the focus back to the main report with the last line.

CrystalReport1.SubreportToChange = <<sub report name>>
    CrystalReport1.SelectionFormula  = <<your selection formula>>
    CrystalReport1.SubreportToChange = ""

Good luck

FW