issue with PDF report from joined tables

[associates]

Hi,

I have problem with pdf-ing a report that has record source coming from a query namely from the two tables joined based on the same of several fields (foreign keys).

I have PDF coding that would turn Access report to PDF report. It has no problem when the report's record source is from one table only.

Just wonder if anyone who might have a similar issue would like to share with me some help. Is it normal that PDF doesn't work if the report comes from joined tables in Access?

Thank you in advance

 

[boblarson]

You don't by chance have lookups defined at table level do you? That is sure to screw around with things.

 

[associates]

Hi Boblarson,

Thank you for your reply.

No, i don't define lookup in that table. I tried it but could not see if it would help solve my problem. (sorry if i misunderstood you)

For example
table "company"
CompanyID
CompanyName
CityID
...

table "City"
CityID
CityName
CityPopulation
CityPostcode
...

I can do lookup for CityID but the thing is in the report, i must have the following fields
CompanyID
CompanyName
CompanySector
CityName
CityPopulation

This is the reason i created a query that combines two tables together based on CityID so that i can grab some of the fields from City table to be shown in the report. This has problem as a result when it comes to PDF-ing the report (i think due to the query).

If this was not what you meant, please guide me.

Thank you in advance

 

[boblarson]

Any chance you can post the database here (after compacting - TOOLS > DATABASE UTILITIES > COMPACT AND REPAIR and then Zipping with WinZip or something like it)?