Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007

    Question Unanswered: Part of Field - Search

    Hi Everyone,

    Is there any way to modify the code below, so that when I type a value in the search field, it will return results that are not equal, but contain what I typed. Right now the code returns the exact search criteria, but I would like it to just return fields that are a part of what the search criteria is.

    Ex: If I type 114 onto the search it returns the all listings that include 114 on the "office" field.

    If Not IsNull(Me!SearchOffice) Then
    Me.RecordSource = "Select * from [Management List] where [Office] = '" & Forms![Management List]!SearchOffice & "'"
    End If

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    where [Office] LIKE '*" & Forms![Management List]!SearchOffice & "*' " | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2007


    Brilliant many thanks!!!!

Posting Permissions

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