Access 2003, Form with Subform based on Parameter Query

Posted on 2008-11-17
Last Modified: 2013-11-28

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
Question by:dfm09
    LVL 84
    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.

    Author Comment


    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

    Accepted Solution

    got it.  worked it out another way. thanks.
    LVL 84
    What was the "other way"?
    LVL 84
    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now