In Access 2003 - I have created a form based on a Parameter query, with a subform based on a Parameter query.
The form works great until I need to edit/update the data displayed in the subform (there is a field that I need to add data into). If I have only one record displayed in the subform the edit goes fine. When there is more than one record in the subform, it re-runs the Parameter query and the dialog pops up displaying the Parameter question.
I need to do the edits in the subform, but I don't need the Parameter query to ask me the Parameter again (not until the form is reopened). Can it be stopped and still have the subform update the table? If so, please how?
thank you, dfm