By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,903 Members | 2,075 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,903 IT Pros & Developers. It's quick & easy.

MS Access Query Criteria Form Does Not Display

P: 5
Hello

I've tried using the MS Access Northwind sample DB and I've downloaded a few other sample Microsoft Access DBs from their website. I keep on running into the same problem for trying to retrieve user input from a query form.

In the Northwind DB, there is a query named "Invoices Filter". In the criteria for the OrderID field in the Invoices table, the following is entered: [Forms]![Orders]![OrderID]

I understand that for this field, it's trying to retrieve user input from the form "Orders" based on the "OrderID" field. But when I double click the "Invoices Filter Query", the form does not display. What happens is that the default dialog box appears with "Enter Parameter Value" as the form caption, a label "Forms!Orders!OrderID", a textbox and an OK command and Cancel command (in the attachment). Why isn't the "Orders" form opening when I double click the Invoices Filter query? Is there something wrong with my settings?
Attached Images
 
May 12 '10 #1

✓ answered by TheSmileyCoder

Welcome to Bytes
That query is meant to be used while the form is allready open. If I recall correctly the query is used to fill a subform of the Orders form. Since the form is not open, the query can not access the data, and that is why it is asking your for a input.

Tell us a bit more about what you are trying to accomplish and we might be able to help you better.

Share this Question
Share on Google+
5 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
Welcome to Bytes
That query is meant to be used while the form is allready open. If I recall correctly the query is used to fill a subform of the Orders form. Since the form is not open, the query can not access the data, and that is why it is asking your for a input.

Tell us a bit more about what you are trying to accomplish and we might be able to help you better.
May 12 '10 #2

P: 5
Hi SmileyOne

Thanks for the quick reply. I'm following this tutorial:
http://www.fontstuff.com/access/acctut08.htm

This tutorial is very similar to what I want to do. Instead of having a dropdown box, I would like to have Yes/No checkboxes. I already have yes/no fields in one of my tables called "Project Leads". Anyways, in step 2.3 in the tutorial, it says I can "Test the query" by pressing the Run button on the toolbar. I thought that if I double clicked the "Invoices Filter Query" this would open the form according to this tutorial.

Would I have to insert the OK and Cancel commands on my custom "Filter dialog box" in order to filter my results based on whichever yes/no fields are equal to -1? Then in the query criteria I would have something along the lines of [Forms]![frmFilterLeads]![chkJoeReed] for each record?

Please note: I am using MS Access 2002 so this may be a newer version.
May 12 '10 #3

P: 5
Ok got it working... That wasn't that hard. I spent my whole morning looking at settings and why this wasn't working in the Northwind and other tutorials. The tutorial above it must be using a more recent version of access.

The bad thing about checkboxes is that there can be three values:
0/-1/Null
I may try to change it to a listbox.
Having 0 and -1 user responses will more likely give unwanted results. Thanks SmileyOne

Now how can I get a report to display instead of the query.........?
May 12 '10 #4

P: 5
just got the report working too :)
May 12 '10 #5

TheSmileyCoder
Expert Mod 100+
P: 2,321
Sounds good.
May 13 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.