Customizing the FindRecord command in Access 97

[bitstix]

In Access 97 I need to customize the FindRecord command so the search defaults to look across ALL fields vs. the current field and finds matches ANYWHERE vs. the WHOLE field. Can this be done? I tried tweaking the code below but kept getting an " Expected = " error message.

DoCmd.FindRecord(FindWhat,[Match As AcFindMatch = acAnywhere],[MatchCase],[Search As AcSearchDirection = acSearchAll],[SearchAsFormatted],[OnlyCurrentField As AcFindField = acAll],[FindFirst])

Thanks for any insight.

Bitstix

 

[MyMainManMoe]

Use the word "Like" instead of "=" in your search criteria