Erin M 2021
Member
- Local time
- Yesterday, 22:26
- Joined
- Apr 14, 2021
- Messages
- 77
Hi there, I've created a report that runs from a form based on the selections within the form (different names). This report is essentially a 'hub' for 4 sub reports. The report runs fine Report View, but when I go to print preview or just try to export, I get an error and it eventually takes me to a blank report.
Error:
Run-time error '2101': The setting you entered isn't valid for this property.
When I go to debug, it references the form.
Private Sub Report_Open(Cancel As Integer)
Me.Filter = [Forms]![Prospect Reports Manager]![Solicitors]
End Sub
What I'm not able to figure out is that these sub reports each are based off the Solicitors within the form and print separately just fine.
Error:
Run-time error '2101': The setting you entered isn't valid for this property.
When I go to debug, it references the form.
Private Sub Report_Open(Cancel As Integer)
Me.Filter = [Forms]![Prospect Reports Manager]![Solicitors]
End Sub
What I'm not able to figure out is that these sub reports each are based off the Solicitors within the form and print separately just fine.