Run Stored procedure as RecordSource

Phil_b

Registered User.
Local time
Today, 18:27
Joined
Oct 7, 2005
Messages
30
Hi,

I have my report setup do that a Stored Procedure is added to the On_Open attribute of a report. Everything works find and there are three parameters:

strRecordSource = "Exec sp_ClientQuery 'UK', 'CF', 'UNITED KINGDOM'"
Me.RecordSource = strRecordSource

I have hardcoded three values in for simplicity although the problem occurs when I try to add more than one value to a parameter. I understand they dont support arrays and so im at a loss to know what to do.

Any help appreciated

Phil
 
You can't directly change the record source of a report on the fly.

However, you can directly.

Specify a query name as the reports record source. Modify the query on the fly. The report will then display the correct data.
 

Users who are viewing this thread

Back
Top Bottom