Filtering CrossTab Data

[JACKSON]

Hi

I have set up a query and a Crosstab Query based on that Query. This works fine, but I am trying to filter the data in the crosstab query to only include the account info for the account the user is viewing.

My crosstab looks something like this :

Account # Result 1 Result 2 Result 3 Result 4

I can static a criteria in the base query (Criteria Account = "1") and it works, but I need the criteria in the query to change based on the record the user is viewing on a specific form. I tried to reference the form ; Forms![formname].[account] but the crosstab query will not run that way. Is there a way through code to change the criteria in a query for a specific field ?? Or do I need to create a recordset and use SQL statements ?

Any thoughts ??

Thanks

 

[pbaldy]

You can use the form, but crosstab queries require that their parameters be explicitly declared. In design view, Query/Parameters.

 

[JACKSON]

Thats probably what I'm missing.
Thanks, I will give it a try