I have a very simple database for an admissions center at Azusa Pacific University.
When a user (no backend, all in one file) runs a report, they are asked a parameter question, (in the query criteria I used [question]. Simple and to the point. the report comes up with a list of students, if you click on a student, a form will pop up with all of the student info, when you close the form, the report (or query I'm not sure) will try to update, or re-run. Therefore asking the parameter questions again.
I need my reports to stop re-prompting until the next time they are opened.
Thank you for your time and help. I am a beginning user with no written code in my database.

-Rusty Goodrick

---

Answer from Richard Rost:

I'm not sure what the problem is, but you can probably get around it by using a FORM to enter your parameter instead of having the query prompt you directly. See this tutorial for details:

If you want to refer to a value on a Form, you can use the notation:

Forms!FormName!FieldName

You can use this notation inside of queries, other forms, or even reports. I have a free tutorial that explains how to use this:

http://599cd.com/tips/access/forms-formname-field-notation?key=BlFAlEx

Note that if you're refering to a value on a SUBFORM, the correct notation is:

Forms!FormName!SubForm.Form!FieldName

Crazy, I know. Enjoy! Hope this helps.