Opening a rpt from a form

[indesisiv]

I have a strange problem (strange to me) with opening a report.
The report is based on 2 tables. (1main 1 sub)

It is opened from a form using
DoCmd.OpenReport "rptVenue", acViewPreview, , "VenueID = " & [VenueID]

This works fine if both the main table and the sub table have data but if the subtable has no data it goes horribly wrong and shows nothing.

The query that the report is based on is set to show all records in the main table regardless of wether there are any records in the subtable. Any ideas???

Steve

 

[R6Flyer]

The problem lies in the report query.

If you look at the join property between the two tables it is set to include all records where the joined field is equal - change this to option 2 , i.e. include all rows from tblVenue and only those records from tblClient where the joined fields are equal.

Cheers

Flyer

 

[indesisiv]

Cheers ... thought that i had already set that.