Printing selected reord

[AMH]

I need to print only one record instead of the whole 109,
I have a form created with a command button that links to
print a report, but I only want to print the newest record.

How do I do that?

Thank you for the help

 

[Jeff Boyce]

If you are trying to print the record that is displayed on your form, you
need to tell the report which record to print. Check the Access HELP on the
OpenReport command -- there's a setting for a filter/WHERE clause that you
can use to say something like (actual syntax may vary):

YourRecordID = Forms!YourForm!YourControlName

(i.e., tell the report that the field that holds the ID of your record can
be found on your form)

Good Luck

Jeff Boyce,
<Access MVP>