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 & "'"