Results 1 to 4 of 4
  1. #1
    clchris_80 is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2013
    Posts
    6

    Filter Split Form using ListBox and .ME

    I have a split form that I want to filter using an Unbound List box in the header of the form. I have entered
    Me.Filter = "[Assigned Technician] = " & Chr(34) & Me.List27 & Chr(34)


    in the After Update Event cell. However when I attempt to use it I receive the error
    "Microsoft Access cannot find the object 'Me'
    How do I fix this?

  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,518
    That's VBA, and wouldn't go directly in the property window:

    http://www.baldyweb.com/FirstVBA.htm

    Also, I think you need this line after that one:

    Me.FilterOn = True
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    clchris_80 is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2013
    Posts
    6
    Thank You sooooo much that works like a charm now! I did forget to past the Me.FilterOn=True on the Forum but I had it all directly in the After Update. Now that I put it in the VBA Event Procedure it works wonderfully. THANK YOU!

  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,518
    No problemo, and welcome to the site!
    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. Query criteria defined by split form filter?
    By stephenaa5 in forum Queries
    Replies: 8
    Last Post: 09-20-2012, 12:34 PM
  2. multiiple filter on a split form
    By webisti in forum Forms
    Replies: 1
    Last Post: 04-06-2012, 12:36 PM
  3. Filter or FindRecord in Split Form
    By P5C768 in forum Forms
    Replies: 4
    Last Post: 03-20-2012, 12:16 PM
  4. Referencing split form data / filter
    By stephenaa5 in forum Programming
    Replies: 2
    Last Post: 09-14-2010, 08:48 AM
  5. Replies: 1
    Last Post: 04-27-2010, 09:30 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