Results 1 to 4 of 4
  1. #1
    cbende2's Avatar
    cbende2 is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Jun 2014
    Location
    Louisiana
    Posts
    370

    Question Simple Filter Question

    Hello all,



    It's slipped my mind on how to do a simple Me.Filter.....

    Code:
    Private Sub Form_Load()
    Me.Filter = "PlanStatusID = 1 OR 2"
    Me.FilterOn = True
    End Sub
    I can't get it to work for "1 OR 2"

    What is the proper syntax for this?

    Thank you!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,524
    Me.Filter = "PlanStatusID = 1 OR PlanStatusID = 2"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    cbende2's Avatar
    cbende2 is offline Competent Performer
    Windows 7 32bit Access 2013
    Join Date
    Jun 2014
    Location
    Louisiana
    Posts
    370
    Quote Originally Posted by pbaldy View Post
    Me.Filter = "PlanStatusID = 1 OR PlanStatusID = 2"
    Much appreciated.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,524
    No problemo!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Help with (seemingly) simple filter
    By TCWAptar in forum Programming
    Replies: 11
    Last Post: 08-11-2014, 11:21 AM
  2. Basic filter question... filter with like
    By Ruegen in forum Programming
    Replies: 9
    Last Post: 12-03-2013, 08:14 PM
  3. Simple VBA Question
    By koper in forum Access
    Replies: 1
    Last Post: 01-20-2011, 12:07 PM
  4. Simple Filter
    By paddon in forum Programming
    Replies: 1
    Last Post: 12-17-2010, 01:07 PM
  5. Creating a simple filter
    By Kipster1203 in forum Reports
    Replies: 3
    Last Post: 05-18-2010, 10:00 AM

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