Printing individual records

[Guest]

I would like to know if there is a way to print an individual record or use
the ID key…. Perhaps a command button that asks what record or id key to
print and then print only that report or form would be sent to the printer… I
can print now but all my records print every time… that’s a lot of paper!!
thanks everyone!!

 

[Albert D. Kallal]

Simply use the "where" clause to restrict he form to the current record

The code behind a button would look like:


me.Refresh
docmd.OpenReport "myReprotName",acViewPreview,,"id = " & me!id

The above assumes you have a primary key of "id" in the table.

The above button can thus be placed on a form..and it will print ONLY the
report with the one record....