How do I create a button to print a report for a specific record?

I've created a form that users can fill out. I want to include a command
button on the form that prints a report that I've created as well. The
problem I'm having is that I can't figure out how to print a report for a
single record. Right now, I can only get it to reports for every single
record in my database.

I've tried to creat a macro to do this, but no luck so far.

Any help would be appreciated.

On Thu, 26 May 2005 08:08:01 -0700, BANKHR wrote:

I've created a form that users can fill out. I want to include a command
button on the form that prints a report that I've created as well. The
problem I'm having is that I can't figure out how to print a report for a
single record. Right now, I can only get it to reports for every single
record in my database.

I've tried to creat a macro to do this, but no luck so far.

Any help would be appreciated.

Your table should have a unique prime key field.

If so, code the command button's Click event:
DoCmd.OpenReport "ReportName", acViewPreview, , "[RecordID] = " &
[RecordID]

The above assumes a [RecordID] field that is a Number Datatype.

If [RecordID] is Text Datatype, then use:

"[RecordID] = '" & [RecordID] & "'"

as the Where clause.
Change the field name to whatever the actual field name is that you
are using.

See Access Help files for:
Where Clause + Restrict data to a subset of records'
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

I assume something on the form makes this particular record unique.
If so the in the click of the button add the code

DoCmd.OpenReport "Your Report Name", acViewNormal, , "[UniqueID] = " &
Me.UniqueID

"BANKHR" wrote:

I've created a form that users can fill out. I want to include a command
button on the form that prints a report that I've created as well. The
problem I'm having is that I can't figure out how to print a report for a
single record. Right now, I can only get it to reports for every single
record in my database.

I've tried to creat a macro to do this, but no luck so far.

Any help would be appreciated.