View Full Version : Please Help? Pop up form to record notes in Report


bluke
08-13-2007, 03:30 AM
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
08-13-2007, 11:34 AM
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.