I am trying to use a list box control on a form to open reports.
OpenReport
ReportName =[Forms]![Form1]![lstReports]
All the reports are spelled exactly as their names are listed in the table reports.
When I try double clicking on one of the names in the list box ( which are being listed correctly) I get:
Macro Name:
ReportList
Action Name:
OpenReport
Arguments:
Baker Owners, 2, , , Normal
Error Number:
2103
Any ideas what is going on?
Thanks,
Tom
- Form name is Form1
- Listbox control is lstReports
- Row Source is from a table listing all report names: SELECT Reports.ReportName FROM Reports;
OpenReport
ReportName =[Forms]![Form1]![lstReports]
All the reports are spelled exactly as their names are listed in the table reports.
When I try double clicking on one of the names in the list box ( which are being listed correctly) I get:
The report name "Baker Owners' you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exist.
Click ok and then the Macro Single Step window opens listing:
Macro Name:
ReportList
Action Name:
OpenReport
Arguments:
Baker Owners, 2, , , Normal
Error Number:
2103
Any ideas what is going on?
Thanks,
Tom