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.