Dynamically selecting Parameter Fields via a Combo Box

[RedWolf3x]

I'll Try to keep this short and sweet.



I know in SQL you can put

Where Table1.Field1 = Forms![Form Name]![Combo Box Name]

How can I make the Combo box Select Which Field to Filter By

The Combo box has a list of fields from the table

Where Forms![Form Name]![Combo Box Name] = Some Value

I'm guessing I'll need to have VBA dynamically create the Query, but I was hoping to avoid having to do that.

Background.

I have a table used for scoring phone calls. It has multiple columns based on different categories. Each month there are incentives given out based off who has "Met" a couple of selected categories for the month.

A query has already been created that pulls the data, however I need to go into the SQL and rewrite which fields are being selected each month. One Month might be Greeting and Gaining Control, the next month might be Closing and Notes. There are 17 categories currently so writing a query for each combination is out of the question.


Thanks.

-Red

[June7]

I doubt can do without VBA.

I use dependent comboboxes and VBA code.

First combobox offers a list of fields. When item selected VBA code sets the RowSource of the second combobox. Then more code builds a critiera string that is applied to form Filter property.

It's a fairly long and complicated coding.

If you want to change the WHERE clause of a query object, that requires code referencing QueryDefs collection.

[RedWolf3x]

Thanks, That's what I was afraid of. Well off to VBA land.