Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print single record from form (2003)

    I used the command button wizard to add a button to print the current form. To then change it to only print the current record, I amended the code to
    'DoCmd.PrintOut acSelection'. However, it still prints all records?! Why? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print single record from form (2003)

    I'd always design a report, and print the report for the current record, but if you want to print the form, use

    RunCommand acCmdSelectRecord
    DoCmd.PrintOut acSelection

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print single record from form (2003)

    Thanks again. (Why doesn't Access give this option in the help?!). I agree - I would rather print a report. Andy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •