Results 1 to 2 of 2
  1. #1
    sevanty7 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Posts
    37

    Question Opening a Report Based on a Single Report Result

    Hello,
    I currently have a search criteria form that when the criteria is entered in it brings up relative records in a report.
    The first report that opens is call "srchDescriptions"


    I would like to have a button beside each related search result record.
    Based on other replies I have recieved I realise I have to base the second report off of the information within the search result
    In each search result I have textboxes that display the information:

    Description
    DateOfCreation
    Plan_Number

    the second Report to open after clicking the button on the individual search result is called "srchDescriptionsAdvanced"

    DoCmd.OpenReport "srchDescriptionsAdvanced"

    is all i currently have. I have no general knowledge of typing out VBA code so please in any replies try and make it simple as I have no clue how to write the code.

    Thank you for any help you can provide me

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I thought we were beyond that here:

    https://www.accessforums.net/access/...dea-35149.html
    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: 6
    Last Post: 05-05-2013, 02:12 PM
  2. Replies: 3
    Last Post: 03-11-2013, 05:11 PM
  3. Replies: 1
    Last Post: 01-10-2012, 03:44 AM
  4. Exporting single query and single report.
    By rfhall50 in forum Programming
    Replies: 2
    Last Post: 02-18-2011, 12:08 PM
  5. Replies: 1
    Last Post: 02-02-2009, 05:52 AM

Tags for this Thread

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