Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    9

    Unanswered: button to Apply a Filter to a Query

    I'm trying to create a simple macro in Access to apply a filter to a query. I want a person to be able to click a button within a FORM which will run this query with a specific criteria which will not stay once she is done running the query and copy/paste the data into excel.

    Actually, it's an underlying query that needs the filter applied, the actual query she will copy/paste is another one that is using the first query as the source data.

    Not sure the best way to achieve this. Pleae help...
    Last edited by cequent; 05-05-06 at 12:31.

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Cequent,

    Why not just use the existing query as a sub-query for your filter? In other words, in Access's query designer, bring up the existing query as the object to query, and build your filter right into the QBE grid. In your macro, just run the upper query.

    Hope this helps,

    Sam

Posting Permissions

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