Results 1 to 4 of 4
  1. #1
    Keefay78 is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    May 2019
    Posts
    36

    Generate report from current open Form

    I have a form where I can search for staff and procedures and filter it down where I can see how many procedures, time taken and average etc, is it possible to have a button to generate a report based on the current open information?



    Photo for example:

    Click image for larger version. 

Name:	frm1.JPG 
Views:	15 
Size:	56.5 KB 
ID:	39157
    I have so far only managed to find a button that opens up a report with the whole database of staff and procedures.

    I can open the Create Report button at the top banner but its formatting etc is way off.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    is it possible to have a button to generate a report based on the current open information?
    Yes; one way being to pass the values of form fields as report filter criteria. There are many ways you could do this, but that might be simplest. However, you don't say how many criteria fields you need. Research ms access open report with filter - or similar to see if it's a method you can use.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Keefay78 is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    May 2019
    Posts
    36
    Quote Originally Posted by Micron View Post
    Yes; one way being to pass the values of form fields as report filter criteria. There are many ways you could do this, but that might be simplest. However, you don't say how many criteria fields you need. Research ms access open report with filter - or similar to see if it's a method you can use.
    this form has 2 search boxes (surgeon and procedure) at the top that filter the records to show what I need, the fields on display are date,orsos, surgeon, procedure, time start, time end and time taken which I would all need in my report.

    I am unsure as how you mean to pass th values from the form fields as report filter criterea (sorry lol)

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It's fairly simple if you're changing the filter property of the form:

    DoCmd.OpenReport "ReportName", acViewPreview, , Me.Filter
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 5
    Last Post: 02-28-2017, 02:45 PM
  2. Replies: 5
    Last Post: 12-12-2016, 07:23 AM
  3. Generate Report that list current training course only
    By TheHarleygirl2005 in forum Reports
    Replies: 6
    Last Post: 09-27-2013, 12:19 PM
  4. Replies: 2
    Last Post: 04-02-2013, 02:24 AM
  5. Open Current Report With Form Button
    By Rick5150 in forum Reports
    Replies: 8
    Last Post: 10-12-2011, 02:28 PM

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