Results 1 to 2 of 2
  1. #1
    Peschtra is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    1

    Creating a report from a form & a parameter query

    I have a database that I want to make a report based on a form that pulls from a parameter query. It kind of works. I open the report and I get the form to enter the parameter, which pulls the query, but then I get another dialog box before I can get the report.




    I don't know how this site works, but I am hoping someone can look at what I am doing and help me. I am new to using the code builder and have tried to get some help from the Google.


    I posted a copy of the database here:
    https://dl.dropbox.com/u/17432409/EC...se%20vb2.accdb


    If you run the report, use Kupfer as the case manager.


    Thanks,
    PK

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,616
    First of all, there is no need to open the query prior to opening the report. Second, I've never seen anyone have report open filter criteria form. Most people open form, enter filter criteria then have button open report.

    The input prompt happens because the form closes before the report runs so the parameter in the query has nothing to get data from. Doesn't matter if the query is sitting there open, running the report forces the parameter to again look for the form for input.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 04-03-2012, 12:33 PM
  2. Query Parameter Displayed on Report
    By hinoks in forum Reports
    Replies: 3
    Last Post: 02-17-2012, 01:56 PM
  3. Parameter Query to report
    By kathi2005 in forum Reports
    Replies: 7
    Last Post: 11-02-2011, 02:00 PM
  4. Replies: 3
    Last Post: 02-15-2011, 05:24 AM
  5. Report with Parameter Query/Form
    By maggioant in forum Reports
    Replies: 0
    Last Post: 10-09-2009, 09:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums