Simple Search form needed

[Paul B.]

Does anyone have a search form or know of a source / sample? I would like to
include a basic search that will try to automatch based on what the user
types, but also find similar matches, ie: if the user inputs 312, the search
would return any record with 312 in whole or part.

This is my second attempt to solve this, sorry if it is repetative, but the
answers I recieved have not led me to a simple solution. Still learning so
the more complex ones are taking too long to figure out.

Thanks

 

[PC Datasheet]

Paul,

Create a query that returns the fields you want including the search field
(ie, the field that has "312" in your example). Put the following expression
in the criteria of the search field:

Like "*" & Forms!NameOfYourSearchForm!NameOfSearchTextBox & "*"

Yout query will return:

312
312AnyhtingHere
AnythingHere312
AnythingHere312AnythingHere