Query using Form to open

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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.
 
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?
Click to expand...

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]
 
Back
Top