Openquery() error

[Mr_Si]

Hi all,

Even though this is query and report related, I think it's likely to be more relevant to this area than the query or report areas.

I am getting the following error:

This is my code:

Basically, I created a report (shown below) based on a query so that I could get the query to show in a user friendly way when a button is clicked in the 2nd page of the switchboard. But I'm getting the above error message

I'd appreciate your help - you've been good to me so far

Thanks in advance,

Simon

 

[namliam]

What is the SQL of your query?
This query is either "no good" or is referencing something it cannot find.

Also using acViewReport to open a query???
You are probably looking for acViewNormal or acViewPreview.

Oh and say HI to bob for me