comments on reports (1 Viewer)

[supportACLU]

I have data pages that users can add comments to...but how can I get the comments sent to a report. Is there a way with an Add-In Manager? or Menu?

Have helped many online with visual basic, java, sqlserver,...please someone email me at caterina@adelphia.net...will continue to do my part in keeping this site welcome to programmers in distress!

 

[pdx_man]

Don't distress, we're here to help! Might need some more info, though.

If it is just the one field, Comments, that needs to be printed, have a report based on the table/query the form is based on.
Have a command button designated "Print this comment"
On the On Click event for the button:

WhereStr = "Recd_ID = " & Me.Recd_ID
DoCmd.OpenReport "Rpt_Comments", acViewPreview, , WhereStr

where Recd_ID is you unique identifier (Primary key) or any other keys to give uniqueness.

HTH