Printing current data in a report

[Guest_imported]

How can I get a report to print just the one record I am looking at.

I want to put a report print button in my form to print each record one at a time.

In my form I created a report preview button but it previews all the records. I want it to just preview the current report. Is there something in my query to make it fetch just the current record I am lookin at in my form??

 

[Garridon]

This web site has some sample code that will help:

http://www.mvps.org/access/

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[gc]

I look at the article "Print only the current record to a report" as follows:
'******************** Code Start ************************
Dim strDocName As String
Dim strWhere As String
strDocName = "rptSomeReport"
strWhere = "[RunID]=" & me!RunID
DoCmd.OpenReport strDocName, acPreview, , strWhere
'******************** Code End ************************

Where does this RunID come from? Access create this ID automatically Or should we create it and how?
George

 

[Guest_imported]

Ok gc,
Here is how it gose, me!RunID, "me" meens the the curent form or "me" could be "form1!RunID".
the "!RunID" is a field on the current form RunID is something you created, it could be "me!ID" or "me!Joe"
ok real eazy....
befor the "!" is the form, after the "!" is the field
Dose this help?