Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Continuous form not filtering

    I have



    Me.Form.Filter = "[SchoolName] like '*" & Me.txtSchoolSearch & "*'" & " and [BookingDate] BETWEEN #" & Me.txtBeforeDate & "# AND #" & Me.txtUntilDate & "#"
    Me.Form.FilterOn = true

    maybe it's the christmas season but I can't figure out why me.txtSchoolSearch comes up as data/member not found

    intellisense sees it...

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    eh

    my mistake

    needed
    Me.Filter = "BookingDate between #" & Format(Me.txtFromDate, "mm/dd/yyyy") & "# and #" & Format(Me.txtUntilDate, "mm/dd/yyyy") & "#" & "and [SchoolName] like '*" & Me.txtSchoolSearch & "*'"
    Me.FilterOn = True

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

Similar Threads

  1. Sorting/Filtering a continuous form
    By Reaper in forum Forms
    Replies: 3
    Last Post: 01-30-2013, 03:07 PM
  2. Filtering a continuous form
    By sbrookebounds in forum Forms
    Replies: 10
    Last Post: 08-14-2012, 09:56 AM
  3. Non-continuous form
    By alyon in forum Access
    Replies: 6
    Last Post: 07-19-2011, 12:25 PM
  4. Filtering a Continuous Form
    By sbrookebounds in forum Forms
    Replies: 5
    Last Post: 12-14-2010, 11:41 AM
  5. Continuous Form
    By duckie10 in forum Access
    Replies: 13
    Last Post: 06-09-2009, 11:15 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