report to open to a specified id number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I want to display all my radio traffic. I want to be
able to use a command button to open the report but have it specify the id
number of the record that I am in only to generate that information. Now I am
able to do this with opening a sub-form but I have not been successful with a
report....

Thanks in advance
Jen
 
Ms said:
I have a report that I want to display all my radio traffic. I want
to be able to use a command button to open the report but have it
specify the id number of the record that I am in only to generate
that information. Now I am able to do this with opening a sub-form
but I have not been successful with a report....

Thanks in advance
Jen
Click to expand...

Look at the code that currently opens the report. It will be using
something like...

DoCmd.OpenReport "ReportName", acViewPreview

There is an optional WHERE argument you can add to this line that will
filter the report when opened.

DoCmd.OpenReport "ReportName", acViewPreview,, "ID = " & Me!ID
 
Back
Top