Grouping Question

[Guest]

My setup: One form ("Soccer or Baseball") and one report. I have two fields
"Designated Area" and "Product Type" that I am working with. "Designated
Area" is the group, and "Product Type" is the restrictor.

There are two options in product type: "Soccer" and "baseball"

Ideally, I only want to display results for either soccer or baseball when
the corresponding "Product Type" is selected. However, tesults from all
Designated Area's are displaying.

Thoughts?

-Adam
I tried changing the control source to =(IIf([Product Type]=Forms![Soccer or
Baseball]!ProductTypeV,[Designated Area],Null)) but it is throwing an error.

 

[Jeff L]

If you are trying to filter your report based on a value in your form
then here's what you do. Your report should be based on a query that
has all the fields you want. Then to filter the correct info, put
Forms!YourFormName!YourFieldName in the criteria of the appropriate
field in the query. Your form must be open for this to work.

Hope that helps!