search

[Guest]

Table with various fields of contact and other information.

I want a search box on a form / switchboard where the user types in part of
whole of the keyword.

On click.. it should find records from all the fields matching that criteria?

Is it possible? how?

 

[Guest]

Set the data source of your form to a query/SQL string. In the criteria for
the relevant field type [Enter part of string] When you open the form it will
ask for the relevant text string (You can use any text you like in side the
[])
HTH

Sheila