• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2182
  • Last Modified:

Move to next record Access report

Hi i am trying to use the KeyDown event of a report to move to the next record using Bookmarks but seems to be that's only working for forms, is there a way how i can go to the next record in report without need to click with the mouse on the record ?
any help appreciated
0
yidel718
Asked:
yidel718
1 Solution
 
mbizupCommented:
Make sure you are viewing the report in Report View (Access 2007 and higher).

If you are simply trying to go to the next record, you don't need bookmarks, just this:

DoCmd.RunCommand acCmdRecordsGoToNext

Open in new window


This won't work in Print Preview, which is static, like a printed page.  Report View, by contrast, behaves a little more like a form.
0
 
Dale FyeCommented:
Unfortunately, Report view also fails to fire some of the Events associated with the report, so if you have code behind the report, don't be surprised if it doesn't work as expected.
0
 
yidel718Author Commented:
needs to make sure to make tabstop of any field other than details to NO, otherwise it will get confused
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now