Incorrect syntax in recordsource

[Guest]

Hi all
I'm setting the recordsource of a subreport as
strQuery = "EXEC Ord_NoCardine"
Me.RecordSource = strQuery

If I run the subreport by itself all is fine, but when the main report calls
the subreport I get the "Incorrect syntax near EXEC" error message..

Can someone help me?

Thanks

 

[Jeff Boyce]

?The name of your query is "EXEC Ord_NoCardine"? That seems like an
unlikely name for a query.

Try using the query name itself ... your error message sounds like Access is
confused about something it is trying to interpret as an EXECUTE command.

 

[Guest]

"Ord_NoCardine" is the name of a stored procedure, there's nothing wrong for
me..
Infact when I run the subreport alone everything is fine...

 

[Jeff Boyce]

If you are running against SQL-Server or another non-JET backend, you'll
need to read up in Access HELP about using pass-through queries.