+ Reply to Thread
Results 1 to 2 of 2

Linking the results from a Form to a Report

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    Arkansas
    MS-Off Ver
    Excel 2013
    Posts
    96

    Linking the results from a Form to a Report

    Currently I have an interactive form that users input data into and a query that runs based off those criteria. The results of the query are displayed, and I cannot figure out how to have a report display instead. I have manually generated a report based off the query results, but I would rather it be automated so the end user does not have to do this. Also, when the report is generated is there a way for there to be a button so the user can go back to the form to set new criteria?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Linking the results from a Form to a Report

    Look at this tutorial on how to run a report from a form.

    http://www.datapigtechnologies.com/f...mtoreport.html
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. linking weekly sales report to monthly sales report
    By sueatcigaretshopper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2012, 09:22 PM
  2. Change form-based report to table-based report
    By drewship in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-27-2009, 08:55 AM
  3. Form Email from Report, Only if Report summary sheet lists Acct for that Sales Rep
    By lukep10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2008, 01:38 PM
  4. Linking a list to a report
    By braydon16 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2007, 01:27 PM
  5. Linking worksheets after runnning report
    By Steve in forum Excel General
    Replies: 0
    Last Post: 02-28-2005, 06:06 PM

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