How to import report without missing recordsource error?

[buienxg]

I have a process that plucks out various reports from other databases and outputs them in pdf format.



However, for some reason, when I import the report object, it tells me the recordsource doesn't exist (since it exists in the other db)

How do I correctly import/copy the report into my db?

[Toyman]

Are you actually "importing" the report from another db to the db you are actually using? If so, then you are actually running the report in your db and the table in which the recordsource is linked is not in your current db. That is why you are getting the error. You can do one or the other. You can run the report and generate the pdf directly from the original db. The other way would be create linked tables in your current db from the tables in which the report is bound. This way, the report running in your current db will have access the the data