Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    20

    Unanswered: send report by mail...but not all the report #)

    I want to send a report by mail but not the complet report, only the pages of the department. what i have is this:

    DoCmd.SendObject acSendReport, "Relatorio_escolha2", acFormatRTF

    know I need to validate the part of the report that I want, to preview a report I used this:

    "Department='" & Me.test & "'" where test is the combobox it the department selected.

    How can i do to this work?

    thanks in advance to u all

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    in this case you should not filter the report but change the record source so it only shows the desired results (maybe make a copy of it and call it MyReportDepartment). Remove the filter from the call to the print preview and add to the recordsource:

    (WHERE ) Department = Forms!MyFormName!test

    hope this helps

  3. #3
    Join Date
    May 2002
    Posts
    20
    thanks

Posting Permissions

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