Adding a Note/Memo to a Report

[hytina]

I have a form used for entry of prototype parts and on this form is a subform used as a purchase requisition. These forms are connected through the ptp number. Once the req is filled out the user can print the req. More then one ptp # can be on a req.. Once the report or form is closed we run a delete query to clear the user information from the req form. It is not data that we need to retain. The report contains info from the rew subfrm as well as unbound text fields for signatures, etc.. I had a memo area on the report but the user must manually fill in the memo once the report is printed.

Now the question is, is it possible to have the memo area be a data entry field that only prints once on the report? I have tried adding it to the reg subfrm, but then the note prints on every ptp # line. I tried to keep the memo as a separate form, but it seems to always come back to linking the memo to something in the req subform, then it wants to print more then once. I hope this makes sense.

I appreciate any comments on this question. My abilities are of the novice level.

 

[cghoga]

Have you treid adding a form footer to your subform and including the notes field there? If not, give this a try.

If you wanted to use a separate form (i.e. named frmNotesEntry) you could include a notes field (i.e. names fldNotes) on that form and have this form open just before the report opens.

Then, on the report in an unbound text field, include in its control source the following:

=Forms!frmNotesEntry!fldNotes.value

Note, to use this field the frmNotesEntry will need to remain open in the background when the report opens, otherwise Access won't know where to get the data for this field.

Hope this helps.

 

[hytina]

Thank you for your response. I have tried the note in the footer of the subform. The only down side to this is that for every part number added to the req rpt a note will print. I was looking for a way to put one memo for the entire rpt. I had tried your second idea,in a somewhat different way and did not have any success. Long story. I like that idea and would really like to get it to work.
I assume the separate form would be tied to a Notes table. A macro opens the form from the main form, type in a note, then use another macro to preview the report. The memo does not present itself on the rpt. I had a window pop up that looked like a parameter query window, asking something like Form ?. Any thoughts?

I appreciate any help and if you need more info let me know.