I have a report that has underlying query, that opens up from form Clientletters.
Expand|Select|Wrap|Line Numbers
- SELECT ClientLetter.LetterID
- FROM ClientLetter INNER JOIN Clients ON ClientLetter.ContactID = Clients.ContactID
- WHERE (((ClientLetter.LetterID)=[forms]![clientletters]![letterid]));
(short of having to make a copy of the report and query and modifying the criteria.)
Regards
PROBLEM RESOLVED USING:
docmd.openreport "ClientLetter",,"LetterID=" & ME!LetterID
Thanks for considering