Setting Report Datasource problem

[wokkie]

Hi,

I am using Access 2003 with a SQL Server 2000 backend.

I want to use a single Report with several different queries, one at a time.

I have the code:

DoCmd.OpenReport "rptJournalMailingLabels", acViewPreview, "qryJournalMailingCurrentIssueSingle"

But this doesn't work. How do I dynamically set the Report datasource?

Thanks

Ian

 

[CosmoKramer]

Ian,

When you say it "doesn't work", what happens, do you get an error message, are incorrect records returned, etc.??

Where is your DoCmd statement located??

Hoc nomen meum verum non est.

 

[wokkie]

There are no records in the report, it seems that the data source hasn't been set.

The DoCmd is behind a command button on a form.

Cheers

Ian

 

[wokkie]

I have managed to set the datasource using the Report's "On Open" method, but this meant than I had to use a combo to select the query I wanted and use a case select statment to set the correct one.

I would prefer to be able to use the DoCmd to set the query.

Thanks

 

[CosmoKramer]

Just don't want to overlook the obvious:

When you run the query independently of the report, do you get the correct records returned??

Also, what is the default record source set to for the report??

Hoc nomen meum verum non est.

 

[wokkie]

The report works fine when run on its own.

The default rs is "qryJournalMailingBase" another query.

Thanks again for your help