Results 1 to 5 of 5
  1. #1
    mr879 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    May 2014
    Posts
    80

    Unhappy UnFiltering certain filtered data

    Filter = ""

    'Trying to unfilter this filtered data without modifying the other filtered data
    'so I tried to name it Filter instead of Me.Filter
    'but Filter="" applies to all filtered data.
    'Is there a way I can name these Filters differently?



    Filter = "[F-Name Match Condition]<>1 AND [F-Name Match Condition]<>15 AND [L-Name Match Condition]<>1 AND [L-Name Match Condition]<>15"

    'I do not want to unfilter this data but it gets filtered by the first statement Filter=""

    Me.Filter = "FirstName LIKE '" & valuFirstName.Value & "*'"
    FilterOn = True
    Last edited by mr879; 05-19-2014 at 01:36 PM.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    A form or report has only one Filter property.

    Do not understand what you are trying to do. How can you 'unfilter' without changing the Filter property? How can you apply a different filter without overwriting the Filter property?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    mr879 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    May 2014
    Posts
    80
    I modified my original post.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Review this example http://www.allenbrowne.com/ser-62code.html of building filter criteria with multiple controls.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    mr879 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    May 2014
    Posts
    80
    I could not find what I was looking for in the link provided but non the less I was able to solve the problem in a different way. In my case I added in another event handler which also filters certain data but will not interfere with my other filtered data because the values will be added to it, since there is no way to unfilter certain parts of the data without effecting all the filtered data like you said.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Filtered Report from filtered datasheet form
    By gemadan96 in forum Reports
    Replies: 7
    Last Post: 01-03-2014, 05:12 PM
  2. Apply second filter to filtered data
    By gemadan96 in forum Forms
    Replies: 2
    Last Post: 12-30-2013, 12:46 PM
  3. Importing filtered data from excel.
    By JOSE LUIS in forum Import/Export Data
    Replies: 1
    Last Post: 04-28-2013, 12:25 PM
  4. Displaying filtered data in subform
    By crxftw in forum Forms
    Replies: 11
    Last Post: 06-17-2011, 09:59 AM
  5. Deleting filtered data
    By mylesg in forum Queries
    Replies: 1
    Last Post: 10-23-2010, 07:18 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums