Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Location
    Illinois
    Posts
    14

    Form that runs query and creates reports


    Hi,

    Is it possible to create a form that submits criteria to a query that will create a report once the query has completed? Or will it require that the query complete and then a second button will need to create the report?

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Valeda,

    What I have done successfully in the past was to use code in the report's Open event sub to set the report's RecordSource, in effect rewriting the query that the report was based on, using criteria in the form from which the report launched.

  3. #3
    Join Date
    Apr 2006
    Location
    Illinois
    Posts
    14
    Thanks, I did get it to work :P

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

Similar Threads

  1. Export Access reports/query results to Outlook Calendar/Task
    By kfinpgh in forum Import/Export Data
    Replies: 0
    Last Post: 02-22-2007, 01:09 PM
  2. Query expression for form
    By pjacob in forum Forms
    Replies: 1
    Last Post: 10-10-2006, 09:12 PM
  3. Form field not displaying in query
    By Valeda in forum Queries
    Replies: 2
    Last Post: 05-05-2006, 10:08 AM
  4. Creating multiple reports from one Query
    By Mike Cooper in forum Reports
    Replies: 5
    Last Post: 04-24-2006, 05:00 PM
  5. Adding Running Balance from Form to Reports
    By KIDGEO3 in forum Reports
    Replies: 1
    Last Post: 01-18-2006, 08:52 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