MS Access - Macro

[Guest]

I'm trying to record a macro that will bring up the 'find' box, and select
'any part of field'. The macro would stop running and allow the user to enter
the text they are searching for. (user is using a form)

The only find function in the macro module looks for something specific.
Will this have to be written in SQL or is there already a function in access
that will allow me to do this?

Thanks for any info provided.

 

[Steve Schapel]

Sophia,

Use a RunCommand action in your macro, and then enter Find in the
Command argument of the macro.