Preview report record from form

[Mike Hughes]

Report named CURRENT BY CASE
Form named NCP/CP AUDIT TBL
Sub form named CURRENT BY CASE
I want to put a command button on the sub form to preview a report called CURRENT BY CASE
But I only want to preview the current record on the form NCP/CP AUDIT TBL, not all the records.

The unique key for each table, form and report is ID_CASE

I know my naming convention is not very good, but that is what I have.

Can someone show me the code needed to make this work?

 

[pbaldy]

This type of thing?

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

 

[Mike Hughes]

Too late tonight will look in the moring...but looks pretty good and it might work for me. Thanks for your time!