You receive a "No current record" error message when you try to print or preview a report, and then you move between pages of the report in Access (888635)
The information in this article applies to:
- Microsoft Office Access 2003
- Microsoft Access 2002
- Microsoft Access 2000
Novice: Requires knowledge of the
user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb) and a Microsoft
Access project (.adp).
SYMPTOMSYou receive a "No current record" error message in Microsoft Access when you try to print or preview a report by using the Print command or the Print Preview command, and then you move between the report pages.CAUSEThis problem may occur when the following conditions are
true:
- Your report is grouped on multiple fields.
- In the Group On group property list, you selected Each Value.
- In the Group Footer group property list, you
selected Yes.
- You have calculations in the group footer.
WORKAROUNDTo work around this problem, use one of the
following methods:
- Change the Group On group property to
Interval for one of the field groups.
- Change the Group Footer group property to
No for one of the field groups.
- Remove the calculations from the group
footer.
Note To troubleshoot the precise cause of this problem, try each of these methods one at a time until you no longer receive the error message. STATUSMicrosoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.REFERENCES
For more information about how to group and how to sort in a
report, click Microsoft Office Access Help on the Help menu, type change sorting and grouping levels in the Search for box in the Assistance pane, and then click Start searching to view the topic.
| Modification Type: | Major | Last Reviewed: | 12/6/2004 |
|---|
| Keywords: | kberrmsg kbReport kbsettings kbprintpreview kbprint kbtshoot kbprb KB888635 kbAudDeveloper |
|---|
|