Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 454
  • Last Modified:

Access 2003, Form with Subform based on Parameter Query

Hi,

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
0
dfm09
Asked:
dfm09
  • 3
  • 2
1 Solution
 
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.
0
 
dfm09Author Commented:
Thanks.

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
0
 
dfm09Author Commented:
got it.  worked it out another way. thanks.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What was the "other way"?
0
 
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.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now