subreport wont filter

[gregst]

I have 2 tables manifest and connote. for every manifest there is 1 or more
connotes and each connote has a manifest number



I edit the manifest
record and I have a button on the page which lets me print the manifest once the
record is saved.

The report manifest has a subreport imbedded in it but
when the manifest prints the subreport prints all of the connotes instead of the
connotes with the same manifest number.

The sub report does not print the
manifest number but I have a query set up that should only select connote
records where there is an appropriate manifest record and as I am asking it to
print the report only for the record I am working on in the form it should not
print all the connote records where there is a matching manifest
record.

what code do I need to put where to stop this happening and
produce a nice manifest with only its connote records printing in the
subreport.

Help please it is driving me bananas trying to fix it.

[rzw0wr]

The print command button is likely a macro.
Change that to a event procedure.

Enter
DoCmd.OpenReport "YourReportName", acViewPreview, , "manifestID =" & ManifestID, acWindowNormal

Use this IF your Manifest ID is a number

Edit:
Make sure your main and sub forms are linked.

Dale
http://www.excelguru.ca/content.php?...-cross-posters