Search results

I need to write a query that searches a field that contains *'s I tried using the Like operator with the Ascii chr(42) but can not get the right results as it seems to return all records SELECT tbl_catalog.upc, tbl_catalog.Caption FROM tbl_catalog WHERE (((tbl_catalog.Caption) Like Chr(42)))...

I need to define a reports recordsource in the Report_Open procdure as I do not want to bind any of the controls in the detail section. How do i do that and how do i referance the recordsource fields in the detail_formatat procedure of the report? Thanks