preview report based on current form's record

Posted on 2006-05-24
Last Modified: 2008-03-06
I'm trying to preview a report with the current form's record set.  Everything I keep trying just shows the report with no data.  Any ideas?

Question by:deloused
    LVL 19

    Expert Comment

    by:Eric Sherman
    What is the Record Source for your report???


    Author Comment

    qry_Report: Inspection

    LVL 8

    Accepted Solution

    Base your report off of a query.

    in the "Criteria" field of the query, add something to the effect of:


    txtboxname can be a textbox, checkbox, radio button, listbox...whatever you want it to be



    Author Comment

    Thank you! That worked beautifully!

    LVL 8

    Expert Comment

    Glad I could help

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now