Rik_StHelens
Registered User.
- Local time
- Today, 15:10
- Joined
- Sep 15, 2009
- Messages
- 164
Hi
I have a report which creates overdue payment notices for any accounts with outstanding balances over 60 days old.
Every time i run the report it gives me the error code 2467 ("The expression you entered refers to an object that is closed or doesn't exist")
When i run debug it shows me the following VB code:
Private Sub ViewReports_Click()
Dim X As Variant
For Each X In ReportList.ItemsSelected
DoCmd.OpenReport ReportList.ItemData(X), acViewPreview
Next
End Sub
And the debugger highlights "Next"
I'm not really VB literate at all so this doesn't mean much to me. I did do some digging around and found a lot of people who had this problem were using subreports, but I am not using any sub reports
Thanks for your time.
I have a report which creates overdue payment notices for any accounts with outstanding balances over 60 days old.
Every time i run the report it gives me the error code 2467 ("The expression you entered refers to an object that is closed or doesn't exist")
When i run debug it shows me the following VB code:
Private Sub ViewReports_Click()
Dim X As Variant
For Each X In ReportList.ItemsSelected
DoCmd.OpenReport ReportList.ItemData(X), acViewPreview
Next
End Sub
And the debugger highlights "Next"
I'm not really VB literate at all so this doesn't mean much to me. I did do some digging around and found a lot of people who had this problem were using subreports, but I am not using any sub reports
Thanks for your time.