Results 1 to 3 of 3
  1. #1
    Candy_Tech is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jan 2017
    Posts
    6

    Search and Print Single Record in a Report

    Hello,



    I am currently trying to create a search button/box to find specific records in a report. The report is a nutritional table and has the textbox "item number" on it. I want a search button/box to search through the "item number" text box that is laid on top on the report.

    I have very little knowledge on Access. I know how to create text boxes, command buttons, combo boxes, ect. I do not know how to write code, but the internet has taught me a thing or two about stringing together code.

    What I want to happen:


    • Type item number in text box
    • Click command button
    • Command button searches records that match the "item number" in the search textbox.
    • Report opens at print preview screen with found-matching record



    Any help/advice is appreciated.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    to open the report to a specific itemno in a preview screen you use

    docmd.openreport "ReportName",acViewPreview,,"[ItemNo]=" & me.Itemno

  3. #3
    Candy_Tech is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jan 2017
    Posts
    6
    Thank you, this works!!!!!!

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

Similar Threads

  1. Print out single record onto a report
    By CQCDave in forum Access
    Replies: 2
    Last Post: 04-23-2015, 06:54 AM
  2. Print out single record onto a report
    By CQCDave in forum Access
    Replies: 14
    Last Post: 01-08-2015, 12:55 PM
  3. Replies: 4
    Last Post: 06-27-2014, 08:02 AM
  4. Print Single Record
    By stattech in forum Reports
    Replies: 5
    Last Post: 10-05-2010, 03:38 AM
  5. How to print a single Record's report?
    By yes sir in forum Access
    Replies: 7
    Last Post: 09-20-2010, 07:31 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