Reports & Strd. Proc.

[Eric]

Hi,

Is it just me, or is running a report with a record source
set to a stored procedure irritating.

Everytime I do something to fix a problem, a new one
arises.

Here's my lastest problem. My report is broken down into
different groups. I use the DoCmd.OpenReport function to
open my reports. I also include the WhereCondition
argument, to narrow my data down. But for some reason, no
matter what I put in the WhereCondition, it's completely
ingored.

Ex. Let's say I have a field (Field1) set as a group
header. I only want the records that have a value of 1 for
in Field1. So I would do this:
DoCmd.OpenReport "myReport", acPreview,, "Field1=1"
The condition will not do anything. It will still show all
records, regardless of what value is in Field1.

(I am using an ADP)

Can someone HELP!!!

TIA,
Eric

 

[Vadim Rapp]

E> Here's my lastest problem. My report is broken down
E> into different groups. I use the DoCmd.OpenReport
E> function to open my reports. I also include the
E> WhereCondition argument, to narrow my data down.
E> But for some reason, no matter what I put in the
E> WhereCondition, it's completely ingored.


check http://support.microsoft.com/?kbid=275089


Vadim