Report Filter from FancyPrairie

[roundup]

Hi FancyPrairie,

I am using your code to filter a report from

http://www.tek-tips.com/faqs.cfm?fid=5497

I am using 4 combo boxes and a text box.

Everything works fine except for one of the combo boxes contains items with an apostrophe. The apostrophe triggers an error:

Run-time error '3075':

Syntax error (missing operator) in query expression
'([ChemSheet].[Field Name]='Norma's Home QTR')'.

How do I fix this problem?

Thanks

 

[TheAceMan1]

How are ya roundup . . .

Try this:

[blue]   ="'" & replace("Norma's Home QTR","'","''") & "'"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[roundup]

Where do I insert this code?

I am not very experienced. Sorry.

Thanks for your help!

 

[TheAceMan1]

roundup . . .

What I posted wasn't necessary:

[blue] Replace ([ChemSheet].[Field Name]='Norma's Home QTR')
With    ([ChemSheet].[Field Name]='Norma'[purple][b]'[/b][/purple]s Home QTR')[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]