Sorting/Filtering and Dropdown Fields: Please Help

[wazawak]

I have been working on a form, but I don’t know how to produce the results that I want. What I envision is a pivot table with a lot of customer/product/promotion information, which is in turn sorted/filtered by dropdown fields for “Customer” and “Event.”

Also, I would like to create calculation fields to process a little of the data from the pivot table.

Unfortunately, my current fields (which I literally copy/pasted from Northwind) have no dropdown functionality and do nothing to sort the pivot table. I can scroll between my customers, but it doesn’t accomplish anything. Does anybody know what to do about this? Any advice would be much appreciated.

 

[neileg]

You need to use a parameter query that uses combo boxes in your form to rpovide the parameters.

 

[wazawak]

What is a parameter query? Is it in the object-> query window? Sorry for the nub questions, this is my first time working with Access. If anyone would be so generous as to provide a simple guide to how to create the proper field (a parameter query?) I would be eternally grateful. I think that if I can figure out how to make a dropdown customer list that will automatically filter the pivot table, I'll be set.

 

[neileg]

A parameter query is one that has an entry in the critera section of the design grid that asks for user input. Instead of using a user prompt that pops up when the query runs, you use a reference to a control on a form which can be a drop down (combo box).