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!O rderID", 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?
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!O rderID", 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?
Comment