Only Print Data Report for Current Record

Posted on 2004-11-19
Last Modified: 2010-05-03

I have a Data report made from the designer.  I'm using a Data Environment connection, linked to an Access db.  On click of a button on vb form, I'm showing this report, but it displays all records.  I went to the 'Advanced' tab on the Command properties and unchecked the box 'All Records' and specified a max of 1 record, nut still the report shows all records.  I was wondering if there is a way to show the report for only the current record in the vb form?

Any help would be greatly appreciated.

Question by:JermyD
    LVL 69

    Accepted Solution

    LVL 69

    Expert Comment

    by:Éric Moreau
    Recommandation: Points to emoreau

    Author Comment

    The link goes to a good article on how to refresh a data report using the CDate function.  I'm having trouble using this info to solve my problem.  I'm trying to print only the current record in a Data report.
    LVL 69

    Expert Comment

    by:Éric Moreau
    This articles shows how to create a command that receives a parameter to filter data and print only those filtered records.

    Change the date to your record ID and your job is done!

    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

    Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
    Introduction In a recent article ( for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    737 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

    17 Experts available now in Live!

    Get 1:1 Help Now