Filter report from combo box to list box

[new2access via AccessMonster.com]

im trying to follow the sales report of northwind database but i have no luck.
..im confused how they did that...

what i have is a training database, i need a report to let the user select
from a list box and filter it using the combo box.. (same as the sales report
of northwind)

what do i need to prepare (tables, query, listbox, combo box, codes, etc) to
do the same? l

can you please show me how they did that?

 

[Jake]

I'm not sure how they did it in Northwind, but here's how I would do it.

Create a form that has your combobox in it. We'll call that "Main Form".
Then Create a subform using the "Subform control".
Create a combobox on the "Main Form"
The Combobox allows you to select the values you want in it. Select the
appropriate field from your table.
Right click ont he Combobox and click properties.
Click on the "Event" tab.
Click on "On Change".
Click the "..." and select code builder.
Type your VB code to change the recordsource for the subform here. Be sure
to use a the selection from the combobox on the parent form in the selection
query.

Every time you change the select from the combobox the subform will update
with the new information.