Results 1 to 4 of 4
  1. #1
    banpreet is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    117

    trying to open up report from search button from a query

    Hey guys, I made a report based on a form with three subforms which two are tables. I have a view button that allows the user to search for the record which works. But when they search the record and the button that is suppoed to open the report it automatically puts that form in the printer queue so they can print it out, but it does not actually go to the actually report so they can view. I don't know why this is happening. Here is my code

    strWhere = "GTSR_ID = '" & Me.GTSR_ID & "' AND Revisions = " & Me.Revisions & " AND TR_ID = " & Me.TR_ID
    DoCmd.OpenReport "TR_Form", , , strWhere

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    DoCmd.OpenReport "TR_Form",acViewPreview , , strWhere

  3. #3
    banpreet is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    117
    ok it works, but nothing shows up the report, how do I link the report to the certain record? Thanks!

  4. #4
    banpreet is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    117
    nvm got it to work

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

Similar Threads

  1. Replies: 4
    Last Post: 02-20-2015, 09:32 AM
  2. Replies: 3
    Last Post: 10-20-2014, 03:25 PM
  3. open report after search
    By shirvo in forum Reports
    Replies: 5
    Last Post: 01-24-2011, 12:21 AM
  4. Button to open a Report
    By 95DSM in forum Reports
    Replies: 1
    Last Post: 07-09-2010, 11:11 AM
  5. Replies: 3
    Last Post: 01-14-2010, 08:32 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