Opening a report with SP as recordsource

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with a Stored Procedure as the record source. The stored
procedure has two parameters. I can open the report just fine with DoCmd and
then give the parameters when prompted but how do I pass the parameters
programatically?
 
Are you talking about a MDB file with linked tables and you are trying to
use a SQL passthrough query as the source of your report or if you are
talking about an ADP project linked to a SQL-Server?

In the case of a passthrough query, you must change its .sql property just
before opening the report. See:

http://www.databasejournal.com/features/msaccess/article.php/3407531

http://support.microsoft.com/?kbid=232493

If it's about ADP, then please go to the ADP forum; on Google:

http://groups.google.ca/group/microsoft.public.access.adp.sqlserver
 
Back
Top