Hi Daniel,

When I made a search form in a database I wanted to search for a person so I created a text box then based a query using the value entered and searched for either a first name or a last name.

The key here is to use an 'OR' with 'LIKE' and the '*' wildcard
I have wrapped the search value in '*'s so that it will find a value that contains that character(s)

SELECT StudentsT.ID, StudentsT.Form, StudentsT.Forename, StudentsT.Surname
FROM StudentsT
WHERE (((StudentsT.Forename) Like "*" & [Forms]![StudentsF]![DescriptionFilter] & "*"))
  OR (((StudentsT.Surname) Like "*" & [Forms]![StudentsF]![DescriptionFilter] & "*"));

(Should really strip the StudentsT. as it isn't necessary as I only have one Table.)



So you are referencing the textbox on the form with [Forms]![FORMNAME]![CONTROLNAME] and searching in the (TABLENAME.FIELDNAME)

All you need to do for your phone number search is add another OR and amend the table/fields to use yours.

There is a Seminar planned for Searching, approx release - Jul 25 [Production Schedule]

There is a Multi Field Search Form tip on this site that might also be useful.

There is a version on the Waiting List that you can vote on too.

Alex