By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

how to Open one Report from different forms

100+
P: 106
Hi,

I have a report that has underlying query, that opens up from form Clientletters.

Expand|Select|Wrap|Line Numbers
  1. SELECT ClientLetter.LetterID
  2. FROM ClientLetter INNER JOIN Clients ON ClientLetter.ContactID = Clients.ContactID
  3. WHERE (((ClientLetter.LetterID)=[forms]![clientletters]![letterid]));
  4.  
How can I modify the criteria, to open same report from another form.
(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
Mar 30 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.