Make a report only show one record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frustrated Newbie - 30 Dec 2005 21:46 GMT

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.

Reply to this Message

Rick Brandt - 30 Dec 2005 22:08 GMT

> I'm sorry, but I'm a total newbie and I need some help.
>
[quoted text clipped - 7 lines]
> It seems like such an easy thing to do, but I can't find directions
> to do this anywhere.

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

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message