Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help with printing a Report

Discussion in 'Information Technology' started by Bob, Jul 28, 2006.

  1. Bob

    Bob
    Expand Collapse
    Guest

    I have made a form that shows all my Clients now I want to put a tick box
    next to there name!
    Which when I tick it will be in the list of Clients to print just there
    name.

    Thanks in advance.........Bob Vance
     
  2. Loading...


  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi Bob,

    Add a Yes/No field to your clients table to store the values
    of the tick boxes

    ie:

    Flag, Yes/No

    then, when you want to print a report for Flag=true, you can
    use the WhereCondition clause of the OpenReport action
    (provided the Flag field is in the Report RecordSet)

    DoCmd.OpenReport "ReportName", acPreview, , "Flag=true"

    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    remote programming and training
    strive4peace2006 at yahoo.com
    *
    Have an awesome day ;)


    Bob wrote:
    > I have made a form that shows all my Clients now I want to put a tick box
    > next to there name!
    > Which when I tick it will be in the list of Clients to print just there
    > name.
    >
    > Thanks in advance.........Bob Vance
    >
    >
     

Share This Page