filter query on combo box in a continuous subform

Sep 14, 2012
Reaction score
hello. i have a similar question to a one that post in the forum but a little different :
I am using a modified 2007 Northwind database. I have added 2 Combo boxes to
the "Order Subform for Order Details" form - "Product Category" and "Supplier ID"
i tried to make it' that when i choose selection from the product category it will filter and shows only the product that belongs to the selected category' and also to make that option to the Supplier combo box to show only the Suppliers that provide the selection combo box of the product
the thing is that when I set the condition in the subfrom it ask me each time by the system massagebox to enter the parameter - Manually.
it's look like it does not recognize the parameter that selected in the previous combobox selection in "Order Subform for Order Details" continuous form.
I set the query conditions actually second combobox as in the picture i attached ..
what i need to change there so that it will run the query true subform ??


  • query subfrom.jpg
    query subfrom.jpg
    9.2 KB · Views: 156

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question