+ Reply to Thread
Results 1 to 4 of 4

Create form to navigate report pages

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

    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
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,887

    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
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

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

    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
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,887

    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.6.0 RC 1