stored procedure as RecordSource

  • Thread starter Thread starter Wm
  • Start date Start date
W

Wm

Ref: Access 2k, SQL 2k

I can use a stored procedure for the RecordSource to a report. That's easy,
I just choose it from the list offered in design view. I can set the input
parameters in design view also, but how do I do that from VBA?

Thanks!
William
 
Basically you need to build the query sql for the pass-thru query in access
and save it before running the report.
 
Back
Top