I have this code for a form on click event
Me.ViewingForm.SourceObject = "report.rptBalanceSheet"
Me.ViewingForm.Report.Filter = "id = '" & Me.CmblandlordsACC & "'"
Me.ViewingForm.Report.FilterOn = True
Where "viewingform" is the name of the subform control
The code runs fine, but after running it goes to the form On Load event and runs the code there - Me.ViewingForm.SourceObject = "frmblank"
I can't figure out why it's doing that?
Me.ViewingForm.SourceObject = "report.rptBalanceSheet"
Me.ViewingForm.Report.Filter = "id = '" & Me.CmblandlordsACC & "'"
Me.ViewingForm.Report.FilterOn = True
Where "viewingform" is the name of the subform control
The code runs fine, but after running it goes to the form On Load event and runs the code there - Me.ViewingForm.SourceObject = "frmblank"
I can't figure out why it's doing that?