SQL Criteria from VBA

[cP6uH]

Hi,
I have a little problem.

If I do following code in VBA, and try to run a report, it works fine, and it filters all the records for the name Jason.

sCriteria = "[Name]= 'Jason'"
stDocName = "Query"
DoCmd.OpenReport stDocName, acViewPreview, , sCriteria, acWindowNormal


But, when I do the following code:

strTest = "Jason"
sCriteria = "[Name] = '" & strTest & "'"
stDocName = "Query"
DoCmd.OpenReport stDocName, acViewPreview, , sCriteria, acWindowNormal

I get input box that asks for Parameter Value for Name field.

What am I doing wrong?

Thanks,

Dragan

 

[chickey]

I have never been a fan of the "multiple inverted comma"
thing - especially when you need to debug it. So, try the
following:

Instead of sCriteria = "[Name] = '" & strTest & "'"
do sCriteria = "[Name] = " & chr(34) & strTest & chr(34)

chr(34) is the inverted commas (&quot character

See if that does the trick.

Regards...

 

[Rick39]

Try

strTest = "Jason"
sCriteria = "Name = '" & strTest & "'"
stDocName = "Query"
DoCmd.OpenReport stDocName, acViewPreview, , sCriteria, acWindowNormal

 

[cP6uH]

Sorry guys... The code that I've put up works fine...
In my original code I had a spelling and that's why it was looking for that Parameter value.... because the field didn't exist in the query.

Sorry once again.