Help with a search routine.

[Takashi]

I already have a crude search setup in my DB using the Access Wizard. It produced the following code:

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

This canned 'find and replace' dialog defaults to match 'Whole Field'. Is there a way to tweak it so the value defaults to 'Any part of field', since this is that the users will utiulize most often?

 

[ott]

Place this line before the DoCmd.DoMenuItem...
line:

SendKeys "{tab}{tab}a{tab}{tab}{tab}"

 

[Takashi]

Exactly what I needed. Thank you very much.