Searching Description Fields

[mriggio]

I am trying to filter or search through a field of a subform. If I have a description that reads: "Document for sales agreement; No signature" and then another description for another record that reads: "Maintenance contract; No signature"; I would like to be able to add a text entry box where I could entry criteria for a search like "no signature" and then a macro that references that criteria and, in the subform, show only those records whose description field contains "no signature." So it's like a filter...

Any ideas.

Thank you so much.

 

[Corticus]

Hi mriggio,

The key is the formula Instr() typed in the field name field in a query like:

searchfor: InStr([rectype],[Forms]![FrmDocType]![TxtSearch])

Adjust rectype to your field name. and [Forms]![FrmDocType]![TxtSearch] to the name of the textbox where you will put your text criteria.

I've posted an example here, maybe it will help:

http://www.theillumni.com/posts/searchstring.zip

HTH,