Query using Form to open

[Bill]

Hi,

I create a button to open the query using Form screen. After selecting
Active Group from the combo list, one of the query works but other query
doesn't work because of Crosstab.

Can you help me how to set this up?

Thanks

 

[Van T. Dinh]

Does the CrossQuery work by itself?

You need to describe the result /error message you get when you try to open
the CrossTab since "doesn't work" doesn't give any info. for potential
respondents to analyse.

Post relevant Table Structure, SQL String of your Query and the VBA code
also.

 

[John Vinson]

Hi,

I create a button to open the query using Form screen. After selecting
Active Group from the combo list, one of the query works but other query
doesn't work because of Crosstab.

Can you help me how to set this up?

If it's a Parameter query, you *must* specify the Paramters for a
crosstab query to work (it's optional for most other queries).

Open the query in design view; select View... Parameters; and add the
parameters (exactly as they occur on the Criteria line) in the left
column and their datatype in the right.

John W. Vinson[MVP]