Report that Prints Last Record

  • Thread starter Thread starter ssmbob
  • Start date Start date
S

ssmbob

When exiting a form I have a macro to Automatically Print a Report ~ I need
to create a report that only prints the last record. I would just use Print
the Form except I Will modify the report to Print the same Field on 50 Labels
~ Once I can get the Report to Only Come up with the Last Record.

Thanks All
 
Define "last".

The WhereCondition of the DoCmd.OpenReport allows you to select a Record or
Records. It is nicely documented in Help in all recent versions of Access,
even the ones where Help in general, leaves something to be desired.

Larry Linson
Microsoft Office Access MVP
 
Larry Linson said:
Define "last".

The WhereCondition of the DoCmd.OpenReport allows you to select a Record or
Records. It is nicely documented in Help in all recent versions of Access,
even the ones where Help in general, leaves something to be desired.

Larry Linson
Microsoft Office Access MVP
Click to expand...
 
I have figured out how to do what I need in a Query!
I don't know how to close this Discussion Yrt but I will Try.
Thank All
ssmbob
 
Back
Top