How to open report base on the current form view?

[alvin8866]

How to open report base on the current form view? I am a noobie in Access, and I try to code a Macro to open the report of current form view which I am doing the data entry. I cannot upload my file..sorry

 

[pbaldy]

You mean this?

http://www.baldyweb.com/wherecondition.htm

 

[alvin8866]

I want to create a commend button in a form to open a report base on the current form data.

 

[pbaldy]

It still sounds like that's a solution.

 

[alvin8866]

You mean this?

Thank you, I actually found that useful. I found that I need to design a report through Query. Then, direct the function to query not to report.

Ex:
Where = [Forms]![Form to be printed]![filed] = [Query]![qry of report]![filed]

Not: Where = [Forms]![Form to be printed]![filed] = [Report]![Report of Form]![filed]

 

[pbaldy]

I'm not sure I understand. You mean the criteria will come from a query rather than a form input?