Make a report only show one record

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

Guest

I'm sorry, but I'm a total newbie and I need some help.

I made a report and I would only like to display ONE record at a time. When
I look at my report, it shows the first record with my header and it looks
nice. It then makes a second page with no header and so on for the rest of
my records. I don't mind being able to navigate between records, but I want
the report to only show one of the records at a time.

It seems like such an easy thing to do, but I can't find directions to do
this anywhere.
 
Frustrated said:
I'm sorry, but I'm a total newbie and I need some help.

I made a report and I would only like to display ONE record at a
time. When I look at my report, it shows the first record with my
header and it looks nice. It then makes a second page with no header
and so on for the rest of my records. I don't mind being able to
navigate between records, but I want the report to only show one of
the records at a time.

It seems like such an easy thing to do, but I can't find directions
to do this anywhere.
Click to expand...

The most common method is to open the report from a form and the code behind the
form supplies an optional WHERE argument value to the OpenReport method which
filters the report's data.

Suppose the form had a ComboBox for choosing the record to see in the report.
The code would look similar to...

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