reports

I am not sure if I am in the right place but I did not find an answer in the
Access newsgroup so I thought I could post my problem here.
I have sp that I am using for a report in Access. The sp looks like this
select os, computerMake from tblComputer where os like @.os\
I am using the do.cmd.OpenReort with the wherecondition. Here is what I have
DoCmd.OpenReport "testos", acViewPreview, , Wherecondition:="com_OS LIKE " &
"'" & OStext.Value
The problem is that I still get a popup asking for the OS. I need the user
to put this in a textbox and then click the button and have the report show
up. Does anyone know what is causing the popup and how I can get around this
?If com_OS is quotable text maybe you forgot the last ', looks like there's
only the first... not sure if that's why your still getting a prompt...
"newguy" wrote:

> I am not sure if I am in the right place but I did not find an answer in t
he
> Access newsgroup so I thought I could post my problem here.
> I have sp that I am using for a report in Access. The sp looks like this
> select os, computerMake from tblComputer where os like @.os\
> I am using the do.cmd.OpenReort with the wherecondition. Here is what I ha
ve
> DoCmd.OpenReport "testos", acViewPreview, , Wherecondition:="com_OS LIKE "
&
> "'" & OStext.Value
> The problem is that I still get a popup asking for the OS. I need the user
> to put this in a textbox and then click the button and have the report sho
w
> up. Does anyone know what is causing the popup and how I can get around th
is?
>