+ Reply to Thread
Results 1 to 4 of 4

Thread: Create form to navigate report pages

  1. #1
    Registered User
    Join Date
    02-04-2010
    Location
    North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    51

    Create form to navigate report pages

    Hey all,
    I have a form with navigation control buttons. I also have a report with multiple pages. What I would like to accomplish is for the form to control the navigation of the report pages. I tried using macros, but I am not savy on how to accomplish this. It may also be easier to use VBA, however I have limited experience with this as well. Can anyone help

  2. #2
    Valued Forum Contributor alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Lake County, Illinois
    MS-Off Ver
    MS Office 2010, 2007 and 2002
    Posts
    1,155

    Re: Create form to navigate report pages

    I am unsure of your request. Are you asking to have command buttons on a form that executes reports? Each button would execute a different report?

    Alan

  3. #3
    Registered User
    Join Date
    02-04-2010
    Location
    North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Create form to navigate report pages

    Sorry for not being clear.
    I have attached a screenshot of what I am trying to accomplish. I want the form in the picture to allow a user to cycle between the pages in the report.
    Attached Images Attached Images

  4. #4
    Valued Forum Contributor alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Lake County, Illinois
    MS-Off Ver
    MS Office 2010, 2007 and 2002
    Posts
    1,155

    Re: Create form to navigate report pages

    In your report, I think if you open the properties, you can set the navigation buttons to "on" or "yes" and this will give you the same feature near the footer of the report.

    See my picture.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0