Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

MS Access - Filtering on sendobject

Options
  • 02-08-2006 3:56pm
    #1
    kin9pin
    Closed Accounts Posts: 959 ✭✭✭


    Hi,

    Does anyone know how I can filter a report that is emailed from MS Access using sendobject? I've managed to apply a filter on acPreview using the stLinkCriteria function, but this method will not work when sending as an attachment.
    I basically have a continuous form listing traders and volumes with a button which I aim to use to email a detailed report filtered by the active trader (a button is attached to each detail row on the form).
    I can generate the email, but the report contains all traders instead of just one.

    Thanks for any advice you can give.


Comments

  • Options
    #2
    kin9pin
    Closed Accounts Posts: 959 ✭✭✭kin9pin


    It's ok, added the following filter to the report and all works well now:
    Trader=Forms!frm_TraderChase![Trader]


Advertisement