Report Where condition in variable doesn't do anything

[freyni]

In my code, I build a where condition to be used in
conjunction with docmd.openreport and I assign it to a
variable vReportCondition.
vReportCondition = "[Sample_Stream] = 'AQU'"

When I run the following:
Docmd.OpenReport vReportName,
acViewPreview,,vReportCondition
the variable vReportCondition has no effect.

When I run:
Docmd.OpenReport vReportName,
acViewPreview,,"[Sample_Stream] = 'AQU'"
the report returns the right results

What am I doing wrong?

 

[Zathras]

Put this line:

  MsgBox vReportCondition

in front of this line (from the first version):

  acViewPreview,,vReportCondition

If that doesn't provide a clue, how is vReportCondition defined? It should be Dim'd as a string.

 

[freyni]

Thanks for the help. I checked the datatype and it is a string. I've used the debug window to monitor the value of the variable. I've even pasted the result into my code to replace the variable - and it works. It just doesn't work with the variable

 

[TonyJollans]

freyni,

I can't see anything obviously wrong and I can't reproduce this in Access 97. There must be something more you're not telling us!

Enjoy,
Tony