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