Help and Support

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

Article ID:888635
Last Review:June 18, 2007
Revision:3.1


Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Office Access database (.mdb and .accdb) and a Microsoft Office Access project (.adp).

SYMPTOMS

You 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.

Back to the top

CAUSE

This 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.

Back to the top

WORKAROUND

To 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.

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

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.

Back to the top


APPLIES TO
Microsoft Office Access 2007
Microsoft Office Access 2003
Microsoft Access 2002 Standard Edition
Microsoft Access 2000 Standard Edition

Back to the top

Keywords: 
kberrmsg kbreport kbsettings kbprintpreview kbprint kbtshoot kbprb KB888635

Back to the top

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.