Using Find Funtion

[bigmerf]

I have a form that displays customer information based on a customer table. Within this table I have a customer # and customer name. On the form, I want to be able to use a button to "find" a customer # and a second find button to "find" a customer name.

I am able to create the buttons and set the focus to whatever field I want to search on, the problem is when searching for the customer name, Microsoft Access wants the WHOLE field to be spelled correctly to find it.

Is there a way to set the property in the search box to read "Any Part of Field" rather than the default "Whole Field"???

Any help would be great!

Thanks.

 

[Cretin]

I create forms with find buttons all the time. When you click on the button it displays the find and replace dialogue box. One think we can set in that box is to match any part of the field.

Cretin

 

[bigmerf]

I'm sorry, I don't understand what you said. Is it possible to set the option to match any part of the field, or not, and if so, could you provide some sample code perhaps that would allow me to do this.......??

Thanks!

 

[obli]

Stated another way...if you use the Command Button Wizard to make a Find button, it will work just as if you click Edit > Find on the Menu bar. You will have a window called "Find What:", a window called "Look in:" and a window called "Match:" with drop-down selections of "Any part of field","whole field" and "start of field".

 

[bigmerf]

Yeah, that I know. But my question is, can you change the "Match" part from the default of "Whole field" to instead default as "Any part of field"?????