Find record button

[JanesC]

I've created a find record button on a form using the wizard. When you click on it Match comes up automatically set to Whole Field. Is there a way of altering the code so the default is set to Any Part Of Field?

Also can I setup an unbound text box for the users to enter criteria rather than enter it in Find What?

 

[B827]

If you want to find a string using the standard find then you can use the * character as a wild card. So putting in

brad*

will find all the records starting with brad such as Bradford, bradley or bradd.

Putting in

*mith*

will finf Goldsmith, smithson etc.


Hope this helps Sandy