DoCmd.OpenReport--where condition

[rickmays]

Does the where condition in the OpenReport method replace the report's underlying record source query or just change/add to it. I think I am seeing evidence of the latter, but can't find it documented anywhere.

Thanks!

 

[rainman89]

It changes it by adding another condition/criteria to the recordsource

 

[rickmays]

Hi and thank you for your quick response. Do you have any idea where in MSDN that may be documented? I have searched, but the description I have found is very brief:

WhereConditionOptionalVariantA string expression that's a valid SQL WHERE clause without the word WHERE.


Thanks!

 

[rainman89]

no, but that statement itself shows that it is a WHERE clause, thereby not replacing the querying, just changing it

 

[rickmays]

Interesting. I've never seen a sql statement with multiple where clauses before. It must be ANDing the wherecondition with the query that's in the report's record source.

 

[rainman89]

Interesting. I've never seen a sql statement with multiple where clauses before. It must be ANDing the wherecondition with the query that's in the report's record source.

I believe that that is what it does.. just throws that little &" And blah=" blah or whatever you have in there

 

[rickmays]

Thanks for your help!