Creating a report based on partial field search

[pirseinkim]

I need to do a report that is based on a partial field search from a form. I have done a few forms that do this, but the results are displayed directly on the form. Instead of the results displaying on the form I need for them to be displayed on a report. I thought it'd be the same as the form, but I'm not getting that it is?



I have a query that has this criteria
Like "*" & [Forms]![frmProspMktME rpt]![SISourceCodeSearch] & "*"

Then I added another field(I had this in my other query when I did the form one but this field seems not to work this time)
[Forms]![frmProspMktME]![SourceCodeSearch] - I don't want a name in front of it, but when I exit the field it puts exp1: I don't want that. In the criteria for this field I have: Is Null or Is Not Null.

Then I thought I could base the report from this.

Anyone have any suggestions. Is there a better way to do this? Is this even possible?

Thanks,
Kim P

[June7]

If you don't want field to show in query then uncheck the box in the design grid.

Why have filter criteria for this field since the criteria just allows everything?