Please Help? Pop up form to record notes in Report

[bluke]

I've been asked to create a typical report with data from a database but add a section for notes via a popup form. Whereas the user with click the button to run the report but first a form would popup to enter notes and these notes would be returned to the report. I've never encountered this type of request, can someone please provide guidance? Is there a simple way of doing this without using VBA (i've never used VBA in my databases). Thanks so much

Bluke

 

[shudini]

If you want to avoid VBA and you are using a report that is bound to a query, you could add a parameter query field to the SQL string of the query.

eg.

SELECT MyField1, MyField2,[Please enter your notes here:] AS notes FROM MyTable;

Then, you can add the notes field from in the report design view.