Printer Report from Current Form on Screen

[jjmom02]

My DB is set up so that the info is typed in a form screen and it should print out from the report screen. Problem is I don't want to print out the entire report everytime i hit print I just need to print that one record once its added. Had a macro set-up but I don't think I did it right.
Any help given would be appreciated, Thank you.

 

[Talismanic]

This should work for you:

DoCmd.OpenReport "ReportName", acViewPreview, , _
"[FieldInReport] = '" & Me.txtTextField & "'"

Where you see Me.txtTextField you would use your field that has the record number that you want to show in the report.

[This message has been edited by Talismanic (edited 08-09-2001).]

 

[Rich]

You will have to save the new record first.