Access 2003, Form with Subform based on Parameter Query


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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Why would you base an editable form on a parameter query, especially a Master/Child form setup? Your Child form should be delimited by your Master/Child link, not by a parameter query.

IOW - base your form on a simple query (no paramters, for example), and let the Master/Child links delimit your data. You can use standard WHERE clauses, but get rid of the parameters.
dfm09Author Commented:

I did this because I need to filter the data in the subform on 2 fields -- and don't know a better way, I am new to this.

The user can pick/type their PO# when the initial form opens (the parameter query asks them for the PO#), then it asks them for the Vendor #.  the main form shows the PO information, the subform shows them only the vendor that they want to see.  but they will need to add info into fields in the subform.

If I knew of a way to have the data filtered by 2 combo boxes (or other way) in the subform, I would gladly do that.  I have tried combo boxes but can't get the second one to filter the data further.

Thanks for any assistance, Diane
dfm09Author Commented:
got it.  worked it out another way. thanks.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What was the "other way"?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
typically here on EE you don't just post a question, ask for assistance, and then state "I'm doing this differently". This is an all-volunteer forum, and while you may have paid for this service ALL the Experts here are paid nothing, and the only thing we get in return is points. As such it's considered bad form to post a question and then delete it with a "not going this way" sort of answer, without some explanation of what you're now doing and how it differs from your original post, or the suggestions of the Experts.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.